Trying to install adventureworks 2016 database

Question

I am a newbie when it comes to sql server, and I am trying to install adventureworks 2016. I clicked on restoring databases, but I cannot find the .bak files, even though I have saved them. Do I need to save the .bak files in a specific place? And then how do I look for them to restore? Thank you!

Thanks everyone for your help! However i am getting this error now when I am restoring the database : ColumnStore Index Error even though I have Microsoft Sql Server 2016. How do I fix this error? Thank you!

The files need to be somewhere that SQL Server has access to. — DavidG, Jun 23 '16 at 22:13
`RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' GO` This will restore the database using the specified file. — Jason Clark, Jun 24 '16 at 07:35

score 6 · Accepted Answer · answered Jun 23 '16 at 23:07

The best way to do that is to copy and paste your .bak file to this path:

C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup

Note that this path is for my SQL Server 2014 version but just follow this kind of path and you will be in backup folder where you need to paste your .bak file.

After that in SQL Server Management Studio go with these steps:

Right click on Databases and then Restore Database
In Source dialog choose Device and click on right button with three dots
In Select backup device dialog choose Add
At this point you will see your Backup folder with .bak files, choose one of them in your case adventureworks 2016 and click Ok.
Wait couple of seconds to to load/proceed .bak file and then confirm with Ok
If everything is OK after these steps you will see your database restored if it is not there you can refresh Databases folder and it will be there.

Trying to install adventureworks 2016 database

1 Answers1