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!

Option 1:

Download and install SQL Backup Free. SQL Backup Free is a free program that can backup SQL databases manually or automatically every day.

  1. Start SQL Backup Free
  2. Select your database from the list on the left
  3. Check "Store backups in local/Network folder" and enter a path
  4. Press "Run Now" button at bottom

That's it! Your SQL database is now backed up.

To automate this process, enable "Schedule to run this job daily" and press "Save Button" from the top

 

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