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.