Hi all, in my current environment, I have a single server SQL 2000 setup that's being replaced. I'm in the process of installing a new SQL 2005 cluster with the thought of taking advantage of 2005 mirroring and clustering, but have a few questions.
1. My thinking is that I can migrate my 2000 databases to 2005, but leave the databases in 8.0 (2000) mode. Are there any issues with this I know they won't take advantage of the 2005 performance boost
2. Some of the apps don't support 2005 yet so I need to leave them in 2000 mode until they do. Is SQL 2005 fully backwards compatible with a SQL 2000 database
3. Will mirroring work on SQL 2005 with a database that is still in 2000 mode
Thanks for any assistance with this!
Migrate SQL 2000 to New SQL 2005 Installation.
Moshfegh
hi Tynman
Yes u can always keep SQL2000 database compatibility level i.e. 80 in sql 2005 by specifying compatibility level in system stored procedure "sp_dbcmptlevel" and give compatibility level as 80 with database name.
Ur command will be: sp_dbcmplevel dbname, 80
KoeiTG
Kate E
Start by running the SQL Server 2005 upgrade advisor against your SQL 2000 installation. This will give you good information on problems that you might need to address. Also, if your applications are purchased, check with the vendors for advice on compatibility. But the bottom line is that every application is unique and the only way you'll know for sure is by carefully testing.
Sorry, I don't know the answer to your question on mirroring.
Paul
Daniel Penalba
Jenska
BUMP!
3. Will mirroring work on SQL 2005 with a database that is still in 2000 mode (compatibility level 80)
Do anyone have an answer to this question
Rob Redford
Most applications will upgrade with no problems but there are a small number of breaking changes in 9.0, even if you stay in 8.0 compat mode. Look up "compatibility" and "sp_dbcmptlevel" in BOL for details.