Can I confirm that I have the process correct and that I have not missed anything ?
I am currently running SQL Server 2005 and want to upgrade to 2008/R2 -
I am running several databases, with triggers and Stored Procedures - also Maintenance Tasks.
Backup the Databases
Backup / Document Triggers
Backup / Document Stored Procedures
Backup / Document Maintanance Tasks
Backup / Document Agent Jobs
Install Sql 2008 as an upgrade
Check DB integrity
Check T / SP / MT / AJ from above
check ERP system - functions in the same way and privilages have not been compromised during the upgrade.
I think this should cover it ?
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.