clock for blog

Office Hours
Mon-Fri 09:00-21:00

How To: Restore Gizmo Database (MS SQL)
Posted by Panagiotis Mantzouranis on 25 October 2018 04:08 PM

Built-in manual restore  (v2.0.367 and newer)

  1. Shutdown Gizmo Server if its running
  2. Launch "Gizmo Service Configuration Wizard" from desktop shortcut and select “Restore Database
  3. Select the backup file (gizmo backup *.gbk or MS SQL database backup *.bak)
  4. Select an import Database name
  5. Click Continue and wait for the restore to complete

 

 

Other restore Methods

 

Follow the steps mentioned below to restore a database from a backup file.

STEP 1: Open your MS SQL Server Management Studio and connect to your database.

STEP 2Right-click Database >> Restore Database:

STEP1

STEP 3:  The “Restore Database” window will display. Select Source “Device” and click the button in front of that to specify the file location:

STEP2

STEP 4: Select the option “Backup media as File” and click on the Add button to add the backup file location.

STEP3

STEP 5: Select the backup file you want to restore and click the OK button:

STEP4

STEP 6: Click the OK button:

STEP5

STEP 7: Verify the information and click the OK button:

STEP6

That’s it!  Now you have restored your SQL server database successfully with confirmation message “The restoration of database ‘SQLDatabaseName’ completed successfully.“.

(1 vote(s))
Helpful
Not helpful