SaaS: Please contact TSM Support for assistance On-Prem: - From the database server, launch and sign into Microsoft SQL Server Management Studio (SSMS) with the specific server name
- From the Object Explorer (on the left), ensure the server's drop down has been selected, right click Databases, click Restore Databases
- From the Restore Database window, under Source click the button for Device and click the button labeled ... to the right
- Click Add to see a list of .bak database backups within the default backup folder or browse to a specific folder as needed
- Click the database (IE: <database.bak>) to be restored
- Click the Options tab on right of the Restore Database window
- Check the Overwrite the existing database (WITH REPLACE) restore option
- 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
- If the destination database name is different from the source, select the destination. Otherwise, click Ok
- Right click on the server name under Object Explorer and click Refresh
- The newly restored database should populate under the Databases dropdown
- Right-Click the newly restored Database and click Properties
- Click on the files 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)
- On the files Files tab, set the owner to satyler
- Click the Options tab and select the latest version available in the Compatibility Level drop down menu
|