SQL Server management studio is the most powerful tool to manage databases in a software development environment. It can handle multiple databases at one time connected to different solutions.
Database backup and restore is a clean operation in SQL server management studio and doesn’t involve any rocket science but sometimes, it does.
Especially, when you create a new database and and restore an existing one there. Commonly, you’ll get an error:
Let’s solve this!
Go to “Databases”, right-click newly created database (which you created to restore an existing database) and “Delete”
Check the box “Close existing connections” and hit “OK”
Right-click “Databases” and click “Restore Database”
Check “Device” and click the three dotted button in front of “Device”
Click on “Add” to select database from the location in your PC
Browse your PC and select database backup to restore (backup should be a .bak file)
Now the backup is added into the grid, Hit “OK”
Let the Process complete, Until you get the notification
Expand “Databases” and your new database is there.