SQL Server 2008 Migration

Question

Hi,

I having experience on SQL migration  (2005 to 2008) in small organization.

But i want to know that, what is the migration process in Large Organizations like around 300+ Servers or 300+ instances and TB of Data.

Are they going to use any tools (Microsoft Tools /Third Party)?

Answer 1

Migration steps will remain same and there is only concern about your database backup and restore.Big organisation have san storages and your data and logfiles reside on san's LUN assigned to DB server and if migration are happening then storage guy can bring your DB files to new server with storage replication concepts with fast speed.You just need to attach those files to your new sql instance and need to perform all post checks steps once dbs are avaialable on your new instance like chnaging compativilty level, running update stats,checking error log etc..

Answer 2

From SQL perspective the process you followed to migrate data in a smaller org will hold good in large organizations too.

You cannot migrate all the 300 servers at once,so you will have to prepare a plan and come up with a detailed checklist on what all are the tasks which needs to be followed.Who all should be informed prior,what all teams will be involved in testing and GO LIVE.

Dealing with 300 servers for migration is not at all an easy task and there should be a well documented plan with proper timeline/mile stones.

In most of the big organizations,there will be SAN admins who will be responsible for moving around large backups or data/log files.They will be having quick way of making the files available to you rather than following old copy methods.

Thank you,

---

Anup | Database Consultant

Blog: www.sqlsailor.com Twitter: Follow me !

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.