Link to home
Start Free TrialLog in
Avatar of jsctechy
jsctechyFlag for United States of America

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!
Avatar of Roberto Rodrigues
Roberto Rodrigues
Flag of Portugal image

You can just attach the new sotrage to the servers.
If using SQL 2005 or higher create a database mirroring and then do a detach attach db.
Avatar of jsctechy

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?
ASKER CERTIFIED SOLUTION
Avatar of Roberto Rodrigues
Roberto Rodrigues
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial