Restore a Database

Download Hospital.bak file.

STEP 1: Right click on Database and then select Restore Database.

STEP 2: Select Devices checkbox and then click on ... box.

STEP 3: Select File option from dropdown then click on Add button to add the location of the .bak file.

STEP 4: From left hand side select your folder location where you have saved .bak file then click on OK.

STEP 5: Verify right files have been selected then click OK.

STEP 6: Done. Hospital Database restored successfully.


SQL Script

USE [master]
RESTORE DATABASE [Hospital] FROM  DISK = N'C:\database\hospital.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 5
GO


Comments (0)