SQLTeam.com | Weblogs | Forums

New Database from .bak file


I have downloaded AdventureWorksDW2016 which is a .bak file. How do I convert this and import as a database in SSMS? Thanks.


See this page

I am not able to post an example code because my system thinks I am trying to do a SQL injection on someone, there is sample code there as well :slight_smile: :slight_smile:


Try to create a sample database and restore the AdventureWorksDW2016.bak with overwrite an existing database option.


Can you not just restore the .bak file as a new database?

I have often done this and never had an issue.