So here goes my list (since i have provided the links, i have refrained from describing the points in detail). The intent is to enable readers to use this as a quick checklist whenever they perform a migration or upgrade SQL Server instances.
- Transfer Logins
- Service Packs, upgrades and hotfixes
- Run DBCC UPDATEUSAGE on all databases to correct any incorrect row or page counts.
- Change authentication mode if required
- Change database compatibility level if required
- Connection string change in applications
- Transfer Jobs - Remove @uid parameter
- Update Statistics - See point 6 in link below (QueryPlan needs to have latest data). Done
by default anyways.
by default anyways.
- DBCC reindex etc
- Configure HA
- Run DBCC CheckDB on all databases to check consistency
- Configure HA
- Run DBCC CheckDB on all databases to check consistency
- Enable full text indexing (disabled after upgrade)
2 comments:
If you would like to take a good deal from this article then you have to apply such techniques to your won webpage. capitalone.com
The newly fashioned plastic Bike Helmet article is then ejected out of the mould. This course of is repeated to fabricate tens of millions of equivalent plastic components. Located in Eastern Pennsylvania, Abtec, Inc. has over 100 years of combined expertise within the design, growth, and manufacturer of customized injection molds and assist tooling. From mildew and half design to prototyping to full production, our team goals to deliver the very best high quality injection molding services and products at the best possible|the absolute best|the very best} value. Bottles are the commonest product manufactured using plastic injection molding.
Post a Comment