Database Migration
Backup of existing database
To back up the existing database, follow these steps:
1. Launch SQL Management Studio and connect to the appropriate instance.
2. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine > Object Explorer > click the ServerName to expand the server tree.
3. Expand Database, select suremdmdb database.
4. Right-click the Database > Tasks and click Back Up.
Back Up Database dialog box appears.
5. In the Database list box, select the suremdmdb database name.
6. In the Backup type list box, select Full.
7. Click Database for the backup option.
8. Click Disk to select the type of backup to destination.
9. Select and click Remove to remove the existing backup destinations.
10. Click Add to add a backup location.
11. In Select Backup Destination dialog box, select the File name.
12. Click browse icon to select the path as c:\Backup in Locate Database Files window.
13. Enter suremdmdb_MMDDYY.bak in the File name box.
MM refers month, DD refers to date, and YY refers to year.
14. Click OK to exit Locate Database Files window.
15. Click OK to exit Select Backup Destination window.
16. Click OK in Back Up Database window to start backup.
A prompt appears on successful completion of backup of database suremdmdb.
Restore database to new server
To restore database to a new server, follow these steps:
1. Launch SQL Management Studio and connect to the appropriate instance.
2. Once you connect to Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
3. Right-click Databases > Restore Database.
Restore Database Window will appear.
4. In Restore Database window, select Device and click the browse icon.
Select backup devices window will appear.
5. In Select backup devices window, click Add.
Locate Backup File window will appear.
6. Locate for the database backup file (as performed in 20.1.1, step no. 13) suremdmdb_MMDDYY.bak and click OK.
7. Click OK in Select backup devices window.
8. Click OK in Restore Database window.
A prompt appears on successful database restore.