Some things I can think of, I'm sure others will have more
Before the Upgrade
- Run the 2014 Upgrade adviser
- Review breaking changes
- Test your app..a lot.
- Make sure your target/upgrade server has the same collation
Post Upgrade
- Ensure the database owner is correct, it will take the name of the user who performs the restore, you'll probably want to change this
- Change the compatibility level of the database to 2014 (you'll want to have tested this as part of your prep) ()
- Update all of the statistics in your database for all databases
- Run a DBCC CHECKDB WITH DATA_PURITY for all databases
- Run DBCC UPDATEUSAGE for all databases
No comments:
Post a Comment