Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore 2008R2 DB to 2012 DB
Message
 
 
To
31/12/2013 11:32:12
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2012
Application:
Desktop
Miscellaneous
Thread ID:
01591150
Message ID:
01591174
Views:
37
>Attaching may get it up a running, but in runs in a compatibility mode as the DB is not migrated to the new 2012 format.
>
>>Also, as alternative, did you try to detach this DB in SQL 2008 R2 Express, copy to another place, attach back in SQL 2008 R2 (from original location) and attach in SQL 2012 from new location?

Hmm, interesting point, I need to check compatibility mode for all my DBs as some I attached, some restored.

UPDATE. Found several DBs with lower compatibility_level, so I am going to bump it up.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform