What are the steps needs to be followed while upgrading an SQL instance ?
- Create a series of checklists
- Back up all important files
- Ensure database consistency
- Reserve enough disk space
- Transfer login information
- Disable all startup stored procedures
- Stop replication
- Quit all applications
- Register your servers after the upgrade
- Repopulate full-text catalogs
- Update statistics
- Update usage counters – DBCC update usage
- Configure your new SQL Server installation
