How to Restore a SQL Database From Backup

Restore a SQL Database From Backup

• SQL Server Management Studio
• Restore Database
• Database Backup
• On-Prem
• SaaS

Database needs to be restored from database backup

SaaS: Please contact TSM Support for assistance

On-Prem:

1. From the database server, launch and sign into Microsoft SQL Server Management Studio (SSMS) with the specific server name
2. From the Object Explorer (on the left), ensure the server's drop down has been selected, right click Databases, click Restore Databases
3. From the Restore Database window, under Source click the button for Device and click the button labeled ... to the right 
4. Click Add to see a list of .bak database backups within the default backup folder or browse to a specific folder as needed
5. Click the database (IE: <database.bak>) to be restored
6. Click the Options tab on right of the Restore Database window
7. Check the Overwrite the existing database (WITH REPLACE) restore option
8. Check the Close Existing Connections option - If these are grayed-out, close and re-open the restore window and choose them before selecting the device to restore from
9. If the destination database name is different from the source, select the destination. Otherwise, click Ok
10. Right click on the server name under Object Explorer and click Refresh
11. The newly restored database should populate under the Databases dropdown
12. Right-Click the newly restored Database and click Properties
13. Click on the files tab and verify or change the filenames to the appropriate environment (IE if munprod was restored to muntrain, the filenames need to be renamed)
14. On the files tab, set the owner to satyler
15. Click the Options tab and select the latest version available in the Compatibility Level drop down menu