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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 when restoring Adventureworks DB

Author  Topic 

asifbhura
Posting Yak Master

165 Posts

Posted - 2008-07-26 : 04:49:06
Hi,

I have downloaded adventureworks DB for sql server 2005.

I created DB in sql server using given script.now i want to have all records for all table.

So, I tried to restore DB with given backup file.

When i tried to to restore Db. then it gives error as given below,


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:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\AdventureWorks.BAK' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

Regards,
ASIF

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-26 : 05:20:35
try download from http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
and follow the installation instruction


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -