Thursday, March 29, 2012

Database Compatability

Hi everybody,
I am currently developing a website backed by an SQL 2000 datatabse, my
question is can I attach the database to an instance of SQL server 2005
and then re attach the same database to the SQL server 2000 that is on the
Production server without it beinfg upgraded to the 2005 format?
ThanksJason
Yes , you can attach SS2000 db to SS2005 instance , but cannot re-attach it
to SS2000 again
"Jason Chandler" <Jason Chandler@.discussions.microsoft.com> wrote in message
news:C9A0F01E-1AE0-4C88-8DAE-FB09BF220C84@.microsoft.com...
> Hi everybody,
> I am currently developing a website backed by an SQL 2000 datatabse, my
> question is can I attach the database to an instance of SQL server 2005
> and then re attach the same database to the SQL server 2000 that is on the
> Production server without it beinfg upgraded to the 2005 format?
> Thanks

No comments:

Post a Comment