We help IT Professionals succeed at work.

moving sql database from dell 220 storage array to iscsi san, cluster environment, any ideas?

357 Views
Last Modified: 2012-06-21
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!
Comment
Watch Question

Roberto RodriguesIT Manager

Commented:
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.
jsctechyInfrastructure Team Lead

Author

Commented:
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?
IT Manager
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.