December 17, 2012 at 8:47 am
I run RESTORE command for 2008 database on SQL 2012 box
and noticed it does some "upgrade". Is it upgrade to 2012?
How to preserve Compatibility level 100 - SQL 2008?
Here is an extract from RESTORE output..
..................
Converting database 'RicohXenApp' from version 655 to the current version 706.
Database 'RicohXenApp' running the upgrade step from version 655 to version 668.
Database 'RicohXenApp' running the upgrade step from version 668 to version 669
............................
RESTORE DATABASE successfully processed 193 pages in 0.672 seconds (2.243 MB/sec).
December 17, 2012 at 8:51 am
Find out for yourself:
SELECT compatibility_level
FROM master.sys.databases
WHERE name = 'RicohXenApp'
John
December 17, 2012 at 9:12 am
It should keep the compatibility level you started with. The upgrades are in the database actual structure, etc. That's usual when restoring from a lower version of SQL Server to a higher version.
Keep in mind, compatibility level just says which old features you want to keep using. It doesn't actually keep the database as an SQL 2008 database. That's why you can't restore from a higher version to a lower version, even if you set the compatibility. It's just a statement of "I need obsolete features to keep working".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply