I'm looking for steps that I need to follow to transfer a database to a new server. So far I have:
- I restored the current database that I have in SQL Server 2005 instance to another SQL Server 2008R2 from backups
- Transferred all the database and security logins, Linked server
- Re-created the SQL Server agent jobs (including an SSIS package) and maintenance plans
- Expanding all the other Objects in SSMS but nothing else to move
- Planning to choose the database task: "Take-Offline" instead of "Detach", not sure why!
- Point an existing application (built on VB)to the new server, and hopefully it will run the reports (thats calling my SQL stored procedures) successfully!
So am I missing anything else that I should transfer?