How to map .bak sample databse file to sql 2008 R2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

How to map .bak sample databse file to sql 2008 R2

Author

Topic

calisonic
Starting Member

32 Posts

Posted - 2015-03-17 : 19:31:14

I need some sample databases so I got one from http://msftdbprodsamples.codeplex.com/

It downloads as a zip file and extracts on .bak file. No idea how to get it to show in SSMS in SQL 2008 R2.

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-03-17 : 19:33:22

A bak file is a backup file, so you'll now need to restore the database. You can use the GUI in SSMS (right click Database and go through the restore wizard, making sure to change the path of the database files) or use RESTORE DATABASE command and specify the WITH MOVE option. Since you are new to backups/restores in SQL Server, I'd highly recommend the GUI.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

calisonic
Starting Member

32 Posts

Posted - 2015-03-17 : 19:38:37

I attempted doing the Restore via the GUI but I got an error when I chose the .bak file from my Downloads folder:

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

The media family on device 'C:\Users\Administrator\Downloads\Adventure Works 2014 Full Database Backup\AdventureWorks2014.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-03-17 : 19:42:24

Did you ensure you downloaded the version that'll work with SQL Server 2008 R2? You can't restore a 2012+ backup file to a 2008 R2 server.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

calisonic
Starting Member

32 Posts

Posted - 2015-03-17 : 19:51:46

Ah, in that case no. Pretty sure these are for 2012 or 14. Any idea where I can find some sample 2008 db's ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-03-17 : 19:55:26

The link you provided indicates other versions.

Or you could install a newer version. Express edition is free.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

calisonic
Starting Member

32 Posts

Posted - 2015-03-19 : 19:50:11

Took forever, but finally found them here:

http://sqlserversamples.codeplex.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources