sql server 2005 > sql server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server 2005 > sql server 2000

Does anyone know if it’s possible to take a database running on sql server 2005, detach it and put it back on sql server 2000? The reason I ask is because I have databases on sql 2000 that I want to move to sql 2005. I want to be able to bail if sql server 2005 doesn’t work out the way I wanted. I tried it once already, but I get index errors. Thanks.
No way to back from 2005 to 2000.
I suggest to backup 2000 restore on 2005 and test.
Luis Martin
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Thanks, that’s what I figured.