3

I'm looking for steps that I need to follow to transfer a database to a new server. So far I have:

  1. I restored the current database that I have in SQL Server 2005 instance to another SQL Server 2008R2 from backups
  2. Transferred all the database and security logins, Linked server
  3. Re-created the SQL Server agent jobs (including an SSIS package) and maintenance plans
  4. Expanding all the other Objects in SSMS but nothing else to move
  5. Planning to choose the database task: "Take-Offline" instead of "Detach", not sure why!
  6. 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?

Mike Fal
  • 12,418
  • 2
  • 47
  • 60
Shayma Ahmad
  • 655
  • 7
  • 18
  • 27

0 Answers0