Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Description of Issue

Restore a SQL Database From Backup

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

Database needs to be restored from database backup

Resolution

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
Additional Information






  • No labels