Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    32

    Unanswered: Moving Replication to a new SAN

    I have Transactional Replication running between 2 DBs on the same server, Publisher,Subscriber and Distributor are on the same server. We are moving all our DBs to a new and faster SAN, including the 2 I am replicating.

    Which is the best way to move them without disrupting replication or having to take it dow and recreate it ?

    Thanks,

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Attach a LUN from the new SAN as a new drive on the machine that runs SQL Server.

    Stop the SQL Service, and set it to Manual so that it won't accidentally restart.

    Copy the MDF and LDF files to the new drive/SAN. Be sure to preserve all folders, etc.

    Swap the disk drive letters between the new and the old SAN drives (effectively swapping the drives).

    Manually restart the SQL Service.

    Check everywhere you can think for error messages. Check again. Ask someone else to verify that things are clean so far.

    Start using your applications, be very careful to see that they work as expected.

    Once you get to this point, the old SAN drives are just excess baggage. They allow you a "fallback to before the switch" just in case anything goes wrong. Once you are comfortable, you can disconnect them from the SQL Server machine.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •