Hello Gurus
I have been on the ms site for hours and cannot seem to get a good
answer for the following question:
Is a .bak file or a backup file that is from a sql server 2008 usable by
sql server 2005
it is not usabe in sql server 2000 we already tried that. We get a file
corrupt message. Any help would be good

Wisord

*** Sent via Developersdex http://www.developersdex.com ***

No you cannot restore a later version to an earlier version regardless of
what version it is. You would need to export all the data from the 2008
version and import it into a similar schema in 2005. Of course if there were
any 2008 specific features used you would have to deal with them depending
on what they were.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Bill_Orova" <nospam (AT) devdex (DOT) com> wrote

You can only restore forward, not backward. Typically two versions.

SQL 2000 can be restored to 2000, 2005, 2008
SQL 2005 can restore to 2005 and 2008.

Same for detach-attach.

Compatibility mode has nothing to do with on-disk format and won't help.

Once a database is restored or attached to a higher version, there is no
direct revert path.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Bill_Orova" <nospam (AT) devdex (DOT) com> wrote