“SQL Odds and Ends”

To restore your SQL backup to a new database, or even restore to another server.

In some cases, we may want to to restore a SQL backup to a new database with a different name to distinguish it from the source database. Sometimes we may even want to transfer the database to another instance or server for migration. This can be frustrating if you are not familiar with the process.
The method can be quite simple, when you know how.
The simple method uses Microsoft SQL Server Management Studio.
Just make sure you've created SQL backups successfully, and stored where you can access readily.
1. Launch SSMS, and connect to your SQL Server target instance.
2. Right-click the Databases node in Object Explorer and select Restore Database.


3. Select Device: and then select the ellipses (...) to locate your backup file.
4. Select Add and navigate to where your .bak file is located. Select the .bak file and then select OK.
5. Select OK to close the Select backup devices dialog box.



6. Choose the Destination Database from the DropDown list.





7. Select OK to restore the backup of your database.