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

• Manual EERP Data Refresh

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

   1. Verify the Destination database is correct

6. Click the Options tab on left 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 .mdf and .ldf filenames in this tab need to be renamed to reflect the correct environment)

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