Skip to main content

How can we help you?

CGM Knowledge Base

SQL Server - How to create SQL Server backups

  1. Last updated
  2. Save as PDF
This article will provide steps on how to manually create a SQL database backup using the SQL Server Management Studio software.

Please Note : Creating a SQL database backup should be done after hours when users are not accessing the system as creating a backup 

1. Log into the SQL Server Managment Studio

2. Open the Database menu option

3.  Right click on TopsData database or the practice's equivalent > Open the menu titled Tasks > Click on the Back Up Option

clipboard_ee4d3ddfb66af6c303ade6531e8e75c65.png

4. The Backup Database dialog window will open that has several settings that can be changed to create back ups with different settings. By default a full backup will be generated.

clipboard_e56d4b3f2741497abf9e8d2c7f3adb6a0.png

5. Click the 'Add' button

6. Use the new dialog window menu to select the desired backup location and name the backup file. The name should end in '.bak' for the file to be created as a SQL backup file. (I.E. TopsDataPreUpgradeBackup01012026.bak). The selected location should have enough space to hold an entire copy of the database.

7. Once a location is selected pressing OK will start the backup.