How to migrate SQL databases to a new SAN volume?

Posted on 2011-05-12
Last Modified: 2012-05-11
I have a virtual machine with a SQL server 2008 installed. All data (MSSQL10.MSSQLSERVER folder) sits on a separate drive from a SAN. I need to move it now from one SAN vdisk to another. Here is how I want to do it and my question is will it work and is it possible to brake something?

- create a new SAN volume and map it on a SQL server
- stop all SQL services
- move everything from an old drive to the new drive
- change the letter of the new drive to the old drive
- enable all SQL services

I would assume that everything should work exactly the same after I do that - am I correct?
Question by:MisUszatek
    LVL 42

    Assisted Solution

    Sounds about right.  I would dismount the database first, move the database and logs file then remount from new location

    Author Comment

    I have a lot of databases in two instances (sharepoint). Will it still work if I just move the data folders and map it as the same drive?
    LVL 39

    Accepted Solution

    First take a FULL backup of ALL your user databases as this may save you lots of headaces and make sure that the exact same paths exists on the new drive.
    Also make sure all the SQL Server system databases are installed in the same path.
    LVL 3

    Assisted Solution

    Can't you just do a storage vmotion since it's a VM and not have to shut down the server?

    Create a new VMFS on the new array
    Migrate the VM to the new VMFS volume.

    Author Comment

    I am not migrating the VM. I am migrating data between two vdisks on a SAN and presenting it to the VM as the volume.
    LVL 3

    Expert Comment

    Maybe I'm confused, but what I see you wanting to do is
    1.  You have 1 SQL Server VM
    2.  You want to move the data volume on that VM from one LUN to another LUN and keep the same drive letter.

    If this is what you want to do, then svmotion is perfect - No downtime.

    Maybe I misunderstand.

    Author Comment

    It is possible but I guess you are talking about the VMware and I have Hyper-v. I also need to do the same on a physical server.

    Author Closing Comment

    I did that without dismounting and it seems to be working OK.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
    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…

    745 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

    13 Experts available now in Live!

    Get 1:1 Help Now