In this article, We will discuss How to restore Backup file(.bak) in Sql Server.
First of all, login into your Sql Server Management Studio.
Goto Databases, right Click on it -> Click Restore Database...
After that a new PopUp Will Come and there We need to Select the backup file(.bak).
To Select the .bak file Check "Device" Radio button and click on browse button beside of it and add that .bak file in it.
After that give your Destination Database name and Which is in below figure,
Then Click Ok.
After few Seconds/Minutes of time the database will be restored Successfully.
Goto your Databases and Click refresh and now you can able to see the Restored database.
0 comments:
Post a Comment