Downgrading MSSQL 2005 DB to MSSQL 2000 DB

Hello all,
Does anybody have any experience in trying to backup a DB from MSSQL
2005 and then restoring it on a machine with MSSQL 2000? Can it be
done? Is it completely impossible?
While at it - Is it possible to do the reverse without problems? Is
MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
smoothly?
Thanks in advance.You can go from 2000 to 2005 and the db will be upgraded to the 2005 format.
But once it is in the 2005 format you can not go backwards. The upgrade is
seamless in and of itself but there may be incompatibilities with your
existing code / app that you might have to deal with. You can use the
upgrade advisor to see first.
http://www.microsoft.com/downloads/...&displaylang=en
--
Andrew J. Kelly SQL MVP
<Baudolino@.gmail.com> wrote in message
news:1128954487.426069.160440@.f14g2000cwb.googlegroups.com...
> Hello all,
> Does anybody have any experience in trying to backup a DB from MSSQL
> 2005 and then restoring it on a machine with MSSQL 2000? Can it be
> done? Is it completely impossible?
> While at it - Is it possible to do the reverse without problems? Is
> MSSQL 2005 100% back-compatible with MSSQL 2000, so I can just backup a
> whole DB on MSSQL 2000, restore it on MSSQL 2005 and have it run as
> smoothly?
> Thanks in advance.
>