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

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

Sort by: Published Date | Most Recent | Most Useful
Comments
  • I want to know how to do that with PowerShell. Been looking everywhere and haven't found anything. I've only found restoring into existing database.

  • I add has image tag

Page 1 of 1 (2 items)