How to Restore a Database Backup Using .bak file in MS SQL Server 2012

Ref: http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-using-bak-file-in-ms-sql-server-2012.aspx

 

How to Restore a Database Backup Using .bak file in MS SQL Server 2012

.bak files are database backups we can restore the Database backup using SQL Server Management Studio.

A. Open SQL Server Management Studio in Object Explorer Right Click on 'Databases' Node and select 'Restore Database'

B.  'Restore Database' Dialog will be displayed on the General page
1. The name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box.

2. Select 'From device'

3. Click button to display 'Specify Backup' Dialog

4. Click 'Add'  to browse the .bak file from the directory and click OK

BackUp and Restore, en-US, SQL Server, SQL Server 2012, SQL Server Release Notes