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:


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


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


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


STEP 6: Click the OK button:


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


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))
Not helpful