How to create a new DB from a .bak file
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?
Sorry we couldn't be helpful. Help us improve this article with your feedback.