Windows 2003 Enterprise Edition (32-bit) - SQL Server 2005
2 servers clustered Active/Passive.
We are looking to migrate the databases over to 2 new servers located at a data center.
Windows 2003 Enterprise Edition (64-bit) - SQL Server 2005
2 servers will be clustered Active/Passive.
I've never migrated an SQL database and I've done some research on the internet to help. I'm not fully in charge of the migration but I am involved in the QA portion of the migration. Being part of the QA team I'm sure knowing how the migration process works would help me come up with a near perfect checklist to ensure that things run smooth.
Any recommendations to resources on the internet would be greatly appreciated. Here are some of my main concerns in regards to the migration.
1. What's the best way to copy/transfer the database environment over to the new server? Over the VPN connection to our data center is not a feasible idea since the database is well over 30GB.
2. Would the database environment need to be copied to both servers or will replication take care of this? I'm assuming that the only one copy is needed on one of the clustered servers.
3. Are there any compatibility issues between the 32bit and 64bit operating systems?
Thanks In Advance!