|
When I restore the databases from sqlserver 2005 to 2008, I see the database properties (options) are defaulting to SQL Server 2000(80). Do I need to change the Compatibility level to SQL Server 2008 (100) for all databases.
(comments are locked)
|
|
Yes, you will have to make this change yourself. If this is a thirdparty vendor database you might want to double check with them as well to ensure they support the upgraded compatibility level. I have only had two vendors out of several hundred where this was an issue. +1 for the 3rd party consideration
Jun 01 '12 at 02:19 PM
Kev Riley ♦♦
(comments are locked)
|
|
If the database was already at level 80 when in 2005, then yes you will need to change the level to 100. There are T-SQL differences between 2000 and 2008, but I'm sure you've already contemplated those if you are upgrading your server? I'd also check the page verification option as this was defaulted to TORN_PAGE_DETECTION in 2000, whereas 2005 and above it is CHECKSUM - it is worth changing this too!
(comments are locked)
|
|
You might also want to run DBCC CHECKDB WITH DATA_PURITY if it was at 80. It's best to do a test migration and work out the kinks/see what pitfalls may be in store.
(comments are locked)
|
