SQL Backup and Restore
To take a backup of your database, do the following:
- Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
- Expand the Databases node from the left-pane aka Object Explorer.
- Right-click the database that you wish to backup, hover over Tasks, and select Back up....
- On the General page in the Destination section select Disk from the Back up to: drop-down list.
- Select Remove until all existing backup files have been removed.
- Select Add and the Select Backup Destination dialog box will open.
- 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.
- Click OK and then click OK again to initiate the backup.
- When the backup completes successfully, click OK to close the SQL Server Management Studio dialog box.
To restore your database, do the following:
- Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
- Right-click the Databases node in Object Explorer and select Restore Database... as shown in the below image.
- 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.
- Select Add and navigate to where your .bak file is located. Select the .bak file and then select OK.
- Select OK to close the Select backup devices dialog box.
- 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.
- 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. ...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 ...Alternative for Full Backup - Trimmed backup
Applicable till 8.1 version (Till 8121 builds) Nowadays the database size is huge in various users instance. It is because the indexing related files, archived files, file attachments are folder are huge in size. Due to which either our application ...How to take a backup in SDP-MSP
Note: In 10.6 when running a backup using backdata.bat/backdata.sh the backup file will be in .ezip format. Backup with .ezip format can be restored to the same database platform only. For example a backup with .ezip when taken from postgres DB ...