clock for blog

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

How To: Backup Gizmo Database (MS SQL)
Posted by Panagiotis Mantzouranis on 11 May 2017 05:01 PM

NOTE: When backing up Gizmo Database in preparation of updating Gizmo server to a newer version, ALWAYS keep a copy of the Gizmo Server folder as well.

You may need to restore your older Server installation in order for your DB backup to work!


Built-in daily backup

Since version 2.0.350, Gizmo has an integrated daily backup scheduler.

To enable the automatic backup:

  1. Go to Manager settings - Server - Backup
  2. Select a backup folder (Default backup folder is C:\Program Files (x86)\NETProjects\Gizmo Service\Data\Backup\)
  3. Select time of day for the automatic backup
  4. Check the "enable" checkbox



Other Backup Methods:

Apart from the built in backup, you can use any 3rd party MS SQL backup tool, for example, SQL Backup and FTP

Download and install SQL Backup and FTP. SQLBackupAndFTP can be used for free and can backup SQL databases manually or automatically every day.


Option 2:

  1. Download and install SQL Server Management Studio (SSMS). You can view step by step instructions here
  2. Launch SQL Server Management Studio and connect to your MS SQL database instance
  3. Expand Databases, right click on your Gizmo Database - Tasks - Backup
  4. Note the backup destination folder for backup retrieval. Press OK to backup database.

Connect to your MS SQL database

Expand Databases, right click on your Gizmo Database - Tasks - Backup

Press OK to backup database

(0 vote(s))
Not helpful