January 19, 2012 at 5:50 am
Does changing the database compatibility from 2000 to 2005 require any downtime or interruption to service? I need to do this without causing any interruption or affecting applications.
Thanks!
January 19, 2012 at 7:12 am
You can change the compatibility level with connections in place. But according to the Books Online, if you do that, you could get incorrect results in queries or other odd behavior. I'd plan for some downtime, just in case. Kick everyone off, take a backup, then change the compatibility level. That way, if things go south, you're in a good position to recover.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 19, 2012 at 10:45 am
To be safer even still I'd run the Update Stats routine after you change compatability.
January 19, 2012 at 10:47 am
Great, thanks to both of you for the help!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply