Steps to restore the database backup
Open SQL Server Management Studio. It will ask for server
credentials. Enter the server name, username, password and click on connect
button.
Right click on the databases and select Restore database
option.
Click on “From device” radio button and select the BAK file.
Enter the database name in the text box “To database”.
Select the checkbox “Restore” as shown below.
Go to “Options” tab, Click on “Restore As” and change the
files name with the database name as shown. Leave the extension (.mdf and .ldf)
as it is.
Click on Ok button, message will be displayed – Restore of
database completed successfully as shown below.
No comments:
Post a Comment