jsctechy
asked on
moving sql database from dell 220 storage array to iscsi san, cluster environment, any ideas?
i was given the task of putting together a project of moving multiple SQL databases that we have on a DELL 220 STORAGE ARRAY to a DELL iSCSI EQUALLOGIC
currently, there are 2 servers connected to the dell 220s via SCSI (active/passive mode), we are looking to move them to 2 brand new servers (in either active/active sql or active/passive sql) and the database will reside on the dell equallogic san... any ideas on how to approach this? would a hot cut be needed? or would i be able to add the 2 new servers to the current environment, and then slowly move over the databases to the new SAN? any ideas, greatly appreciated!
currently, there are 2 servers connected to the dell 220s via SCSI (active/passive mode), we are looking to move them to 2 brand new servers (in either active/active sql or active/passive sql) and the database will reside on the dell equallogic san... any ideas on how to approach this? would a hot cut be needed? or would i be able to add the 2 new servers to the current environment, and then slowly move over the databases to the new SAN? any ideas, greatly appreciated!
ASKER
The nodes will also be new too, so we are essentially moving this to a total new environment
old setup is 2 servers connected to the storage via scsi, new setup is 2 brand new servers connected to a different SAN via iSCSI
any thoughts on the process of how to move to the new servers?
maybe setup database mirroring, and then change the virtual hostname and IP to what the old one was?
old setup is 2 servers connected to the storage via scsi, new setup is 2 brand new servers connected to a different SAN via iSCSI
any thoughts on the process of how to move to the new servers?
maybe setup database mirroring, and then change the virtual hostname and IP to what the old one was?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If using SQL 2005 or higher create a database mirroring and then do a detach attach db.