Win Server 2016
SQL Server 2016
What is the proper way to restore a database from a .bak? I have run into several issues with the infamous error “database is still in use.” The only way I have been successful is as follows:
Stop App Server
Right click DB > Tasks > Restore > Database
Select Device > Add .bak file to restore (Checked overwrite the existing database, Restore with recovery)
Database successfully restores, however, something strange happens:
If I look in the Object Explorer window, one of the databases goes to (Restoring…) and stays in that mode. I’m not sure why as I’m restoring from a .bak. Has anyone else seen this happen when restoring from a .bak file?
If anyone can offer any suggestions, they would be greatly appreciated.