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 Programming
 restore error

Author  Topic 

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2010-09-30 : 11:35:00
Hi friends,

I'm attaching mdf & ldf files on my sql server 2005 server using SSMS, but I get this following error.. Not sure why

The database '....MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.

Our client is also using sql server 2005 and they took a backup of the files from SSMS.. Will it work if they send us a logical backup of the database?

Any suggestions please.. thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-09-30 : 11:50:50
Your client has SQL Server 2008 and has used this to do the backup. This can not be downgraded as it writes to the system tables.
Go to Top of Page
   

- Advertisement -