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
How to restore your data in ServiceDesk Plus
1. Stop the ManageEngine ServiceDesk Plus service from the Services console(services.msc). 2. Click the Windows icon and select Command Prompt (Admin). 3. Go to Bin directory and run restoreData.bat 4.Browse to the backup file from backup ...Restore Related Issues
1. Violation of PRIMARY KEY constraint 'ViewConfiguration_PIDX_PK' 2. Incorrect syntax near the keyword 'key'.java.sql.BatchUpdateException: Incorrect syntax near the keyword 'key' 3. Violation of UNIQUE KEY constraint / Cannot insert duplicate key ...Unable to restore
1.CRC (9412-9423): Download 7zip and extract the contents. The corrupted files will be listed during extracting (but those files will be extracted in the specified location). Replace those files again in the backup using 7zip (Drag those ...How to generate logs during restore process
Refer to the steps to redirect logs to a text file while initiating restore process: From the command prompt invoke restoreData.bat file from [SDP-Home]\bin directory. CMD> C:\ManageEngine\ServiceDesk\bin> restoreData.bat >out.txt out.txt will be ...SQL Server High CPU - To collect queries consuming CPU resources
1. To get an idea of how much CPU the queries are currently using, out of overall CPU capacity, run the following statement: DECLARE @init_sum_cpu_time int, @utilizedCpuCount int --get CPU count used by SQL Server SELECT @utilizedCpuCount = COUNT( * ...