BACKUP/RESTORE compatibility between 2000/2005

Hi
If I take a backup of a database with compatibility level 80 from SQL Server
2005, will I be able to restore that backup into a SQL Server 2000
installation?
Thanks
Mark
No. Compatibility level is for client connection behavior. On-disk it is
still SQL 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mark Rendle" <m.a.r.k@.big.pink.pig.com> wrote in message
news:uER4IyW5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> Hi
> If I take a backup of a database with compatibility level 80 from SQL
> Server 2005, will I be able to restore that backup into a SQL Server 2000
> installation?
> Thanks
> Mark
>
|||Oh. Boo.
Side-by-side installation for me then.
Thanks for the speedy response.
Mark
|||What if I detach a 80 compatibility database on a Sql2005 server, can I
attach on a SQL2000 server?
We are running some compatibility testing against a vendors database and
they are not facilitating our migration to Sql2005. So we need an ability to
get them a zipped up copy of a 80 compatibility, Sql 2000 backup but want to
run in Sql 2005 so we can take advantage of database mirroring. (yes I know
it won't be supported by MS in production for another month or two or three,
that works with our migration schedule)
thanks
"Geoff N. Hiten" wrote:

> No. Compatibility level is for client connection behavior. On-disk it is
> still SQL 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Mark Rendle" <m.a.r.k@.big.pink.pig.com> wrote in message
> news:uER4IyW5FHA.1864@.TK2MSFTNGP12.phx.gbl...
>
>
|||No, once it is attached or restored to a 2005 instance it can not go back
intact. The only option is to keep a 2000 db that is empty and import the
data from 2005 to 2000. That is assuming you haven't changed the schema or
used any 2005 features such as new datatypes etc.
Andrew J. Kelly SQL MVP
"paul" <paul@.discussions.microsoft.com> wrote in message
news:3F5102B7-DB1D-4367-8B0B-C5D69B758498@.microsoft.com...[vbcol=seagreen]
> What if I detach a 80 compatibility database on a Sql2005 server, can I
> attach on a SQL2000 server?
> We are running some compatibility testing against a vendors database and
> they are not facilitating our migration to Sql2005. So we need an ability
> to
> get them a zipped up copy of a 80 compatibility, Sql 2000 backup but want
> to
> run in Sql 2005 so we can take advantage of database mirroring. (yes I
> know
> it won't be supported by MS in production for another month or two or
> three,
> that works with our migration schedule)
> thanks
> "Geoff N. Hiten" wrote: