Skip to content

02-Restore-database.md

Latest commit

 

History

History
33 lines (27 loc) · 1.64 KB

02-Restore-database.md

File metadata and controls

33 lines (27 loc) · 1.64 KB

Restore the database in SSMS

Check that this step has been completed before START

5

  • Launch SSMS
  • Connect to the SQL Server
  • Download the sample database files

To restore a database in SSMS, follow these steps:

3

  1. Copy the sample database files and locate the MSSQLSERVER folder in Program Files (x86)
  2. Open the Backup folder and add the sample database files to the data files.

4

  1. In Object Explorer, right-click the Databases node and select Restore Database.

  2. In the Restore Database dialog box, select the Database to restore.

  3. In the Source section, select Device and then click the ellipsis (...) button to locate your backup file.

  4. Select Add and navigate to where your .bak file is located.

  5. Select the .bak file and then select OK.
    6

  6. In the Destination section, confirm that the Database box is populated with the name of the database to be restored.

  7. To change the name of the database,enter the new name in the Database box.

  8. In the Restore options section, select the following options:

  • Overwrite the existing database (WITH REPLACE)
  • Close existing connections to destination database
  1. Click OK to start the restore process. 7 8 For more information to restore a database backup using SSMS Here