Steps for backup and restore sql server db
- Ensure application server is stopped.
- Login to Dev Server and launch SQL Server Management Studio
- Expand the Databases node in Object Explorer.
- Right-click on the database, hover over Tasks, and select Back up
Select the path and click ok to begin backup
restore
- Ensure application server is stopped
- Login to server and launch SQL studio.
- Right click on database and click on restore.
- Select the .bak file to restore
Ensure name of db is same and version of your server is similar before restore starts.
Application server is stopped but I keep getting a message saying the restore failed because the database is still in use. Can't figure it out because the application server has been stopped. Any suggestions?
ReplyDelete