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

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

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

    
Not an answer but a suggestion: if you can I would push to 2012 or 2014 rather than just to 2008r2 (especially if you have yet to fully test your code against 2008r2). This will save you needing to test your application against a new version again when 2008r2 falls out of support and gives you access to 2012's nice additions (lag and lead window functions which can make certain report type queries massively more efficient, and so forth) should you need them. –  David Spillett 2 days ago

1 Answer 1

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

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.