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.
| Author |
Topic |
|
dahara
Starting Member
2 Posts |
 Posted - 2011-12-06 : 16:31:40
|
| Hello;I am the tech lead in a small shop for 3 different projects. As such, I have both Sql Server 2005 and 2008 installed on my dev machine. I have run into a problem attempting to restore a local copy of a client's Sql Server 2008 db. I am getting this error:Msg 3241, Level 16, State 7, Line 1The media family on device 'C:\[clientdb].bak' is incorrectly formed. SQL Server cannot process this media family.Msg 3013, Level 16, State 1, Line 1I know this is not a corruption issue as when I attempt to attach the mdf file, I get an error message indicating that my internal version for Sql Server 2008 R2 is 611, whereas the db I am trying to restore is 661. I did in fact verify the internal number on Sql Server 2008 by executing this command:DBCC TRACEON (3604); GO DBCC DBINFO GO DBCC TRACEOFF (3604); (it's 611)And upon some research, I am realizing that 611 is the internal version number for Sql Server 2005. So it would seem that the problem is I am trying to restore a db whose internal version number is higher than my local Sql Server 2008. So my questions are:1. Is the internal version number for my Sql Server 2008 R2 611 because I am also running 2005?2. Is there a way to up my 2008 version from 611 to 661?Thanks much |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dahara
Starting Member
2 Posts |
Posted - 2011-12-06 : 16:58:01
|
| Hi Tara;Thanks so much for your reply - I'm close to resolving this. I am now realizing that when I log into 2008, I am actually logging into a 2005 instance (figured this out after stopping the 2005 service - it wouldn't log in and gave me a network related error). One of our tech guys installed the 2008 version, so I don't know the name of the instance he created. How would I go about getting the 2008 instance name? I'm guessing that once I log into the right instance, I'll be able to restore the db. Thanks,David |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Internal Version Number Problem