How to create a new DB from a .bak file
Print
Modified on: Sat, 23 Apr, 2016 at 7:29 PM
Below are the steps to follow to create a new database from a database .bak file:
-
Log in to MSFT SQL Server Management Studio
-
Right click the "Databases" folder and select "Restore files and file groups"
-
In the "To database" field enter the desired name for your new DB
-
Select the "From device" radio button then select the .bak file from the directory it is located
-
Click the checkbox next to the DB set you wish to restore
-
Click OK and your database will be created from a .bak file
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.