http://www.sqlservercentral.com/blogs/steve_jones/2007/03/17/the-great-migration/ Printed 2015/02/28 12:03AM
The Great MigrationWe migrated to a new set of servers tonight. Actually am for the Red Gate folks and a late, 11pm-2am night for me. Things went pretty smooth. I disabled the web site to prevent access, then ran diff's of all the databases. We'd moved fulls over earlier, so once these were transferred, we loaded htem and things looked good.
We ran through tests, rebuilt indexes, and things were ok. A couple password changes that hadn't synched for some reason, but those were easily fixed. We're getting the Euro date display format in some places, not sure why.
Let us know if you see anything,