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

Posted on 2011-04-28
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!
Question by:jsctechy
    LVL 2

    Expert Comment

    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.
    LVL 1

    Author Comment

    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?
    LVL 2

    Accepted Solution

    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.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now