?
Solved

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

Posted on 2011-04-28
3
Medium Priority
?
346 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!
0
Comment
Question by:jsctechy
  • 2
3 Comments
 
LVL 2

Expert Comment

by:SOFTECNICOS
ID: 35484077
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.
0
 
LVL 1

Author Comment

by:jsctechy
ID: 35484297
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?
0
 
LVL 2

Accepted Solution

by:
SOFTECNICOS earned 2000 total points
ID: 35489846
If the new nodes are a new cluster different name to the network, in that case i will do everything from the scratch wich is create the cluster with the new storage and the detach and attach the bd at the new cluster and change the connections .

But if the nodes belong to the same cluster but they are replacement nodes in that case i just add them and unplug the old ones removing them from the cluster and the BD insides move them to the storage by detach and attach in a stop hour.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question