SQL Backup and Restore

SQL Backup and Restore

To take a backup of your database, do the following: 

  1. Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.

  2. Expand the Databases node from the left-pane aka Object Explorer.

  3. Right-click the database that you wish to backup, hover over Tasks, and select Back up....



  4. On the General page in the Destination section select Disk from the Back up to: drop-down list.

  5. Select Remove until all existing backup files have been removed.

  6. Select Add and the Select Backup Destination dialog box will open.



  7. Enter a valid path and file name in the File name text box and use .bak as the extension to simplify the classification of this file.

  8. Click OK and then click OK again to initiate the backup.

  9. When the backup completes successfully, click OK to close the SQL Server Management Studio dialog box.

To restore your database, do the following:

  1. Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.

  2. Right-click the Databases node in Object Explorer and select Restore Database... as shown in the below image.



  3. On the General page, use the Source section to specify the source and location of the backup sets to restore. Select Device:, and then select the ellipses (...) to locate your backup file.

  4. Select Add and navigate to where your .bak file is located. Select the .bak file and then select OK.

  5. Select OK to close the Select backup devices dialog box.

  6. In the Destination section, the Database box is automatically populated with the name of the database to be restored. To change the name of the database, enter the new name in the Database box.

  7. Select OK to restore the backup of your database.


                  New to ADSelfService Plus?

                    • Related Articles

                    • Backup & Restore (from 14000) - Behavior changes

                      Backup: POSTGRES & MSSQL: -> When taking a backup using the command backUpData.bat/backUpData.sh the backup will be created in the EZIP format. This is the native model of PGSQL / SQL. -> When taking a backup using the command ...
                    • Steps to take PGSQL Dump Backup and Restore

                      PGSQL – DUMP – Backup Procedure : Login to the MSP application server and perform the below steps, 1. Start the application To take Postgres (Psql) Dump : 3. Open a command prompt and navigate into <ServiceDeskPlus-MSP>/pgsql/bin directory. 4. ...
                    • SQL Backup permission post 10.6 Upgrade.

                      Error on the logs: [20:00:50:193]|[04-25-2022]|[com.adventnet.taskengine.backup.DbBackupTask]|[INFO]|[124]: BackupStatus updated in DB :: <BackupStatus backup_id=1806 backupType="FULL_BACKUP" ...
                    • How do I restore the backup data?

                      NOTE: For builds > 10.6 While migrating to different database you can use backupdataold.bat / backupdataold.sh. Here backup will be in .data format and this can be restored in across DB platform. While restoring .data file we have to use below ...
                    • Unable to restore database : zip file too large

                      In oldest versions like 8.0, 8.1. 8.2, 8.3, you may come across restore issues when the backup file is huge (even more than 3 or 4GB). In those cases, this article would be helpful. Scenario 1: If you come across this when you are trying to setup UAT ...