Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm making a move from SQL Server 2008 to SQL Server 2008 R2 (Azure VM) as part of a hosting provider switch (from MyHosting to Azure). Should I update the VM to R2 SP2 before restoring the db's or do the update after or don't even do the update?

share|improve this question
add comment

migrated from stackoverflow.com Feb 13 '13 at 23:59

This question came from our site for professional and enthusiast programmers.

1 Answer

That does not matter. When you upgrade an existing instance with a database attached SQL Server automatically upgrades the database too. If you attach the database after the upgrade, it goes through the same process.

In either case make sure that the database is at the right compatibility level. While usually nothing happens, you might run into problems if the database is still at 80. Changing the compatibility level however will change behavior, so make sure you test you application well.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.