Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2010-04-01 : 10:00:44
|
| I am having some i\o buffer problems in one of my instances - MS SQL server 2005 SP3I also have several databases that were not upgraded to 90 compatibility mode when they were migrated from SQL Server 2000 to 2005 using [code="other"]Exec sp_dbcmptlevel @dbname = 'ChangeManagement', @new_cmptlevel = 90 ;[/code]I found this script on this site that you can run against the DB still in 80 compatibility to check for inconsistancieshttp://www.sqlservercentral.com/scripts/Compatibility/62093/I did find some inconsistancies when I ran the script against my 80 Compatibility mode DBsMy question is ... Does anyone know if running [code="other"]Exec sp_dbcmptlevel @dbname = 'ChangeManagement', @new_cmptlevel = 90 ;[/code]to change these databases to 90 compatibility mode is an online operation? is it disruptive? These are production databases and I don't know if I need to get a window to do this off-hours. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-01 : 10:11:52
|
"Does anyone know if running to change these databases to 90 compatibility mode is an online operation?"Your bigger problem will be, IMHO, that you should perform a full regression test on Compatibility Mode = 90 before making the change ...... and if you are going to go to all that trouble you would, again IMHO!, be better to do that with SQL2008 / Compatibility mode = 100, and go straight to SQL2008 - rather than having to do the regression test again "some-time-soon"  |
 |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2010-04-01 : 10:19:27
|
| Thanks. I hear ya and I respect your humble opinion :)I actually have two other posts going http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142181http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142366been having problems with this server for 2 days and this morning the default instance became unresponsive and i had to reboot.. not good.. just trying to figure out what happened.. I did not migrate all of these DBs to 2005 and there are too many that are still in 80 compatiblility mode.. didn't know if maybe that was causing my problems. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Compibility mode question