Migration from 2008/R2 to SQL2016

Kristen November 28, 2016, 3:02pm 2

gpc44:

migration from SQL 2008 / R2 to SQL2016

Upgrading to SQL2012 / SQL2014 SQL Server Administration

I've copied this thread over from the old forum so I can add to it over time Are there any recommended documents / BLOG articles, on upgrading (in my case to SQL 2014)? We will be installing new hardware, so I will be restoring onto the new hardware, rather than upgrading in-situ. Some of the things I've been thinking of include: Pre-create databases in order that I can the most optimal VLFs (before restoring any backups) I have some databases with Compatibility Level = 80. There is no goo…

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled