asked on

Moving a partition

On a raid 1 with two 72gb hdds with just one partition, I have the SQL databases and voice recording avi files(something to do with our telephone systems).Which shows up as D drive on windows 2003 box. I am planning to upgrade the raid 1 with two 142GB hdds and replacing the D drive. So I have created E partition on windows and copied the data with robocopy command. On the planned outage I would change the drive letters by stopping the SQL databases and the application service. Would this work any suggestions?

NutrientMS

Would work how ever you will have to detach your SQL databases then move them to the new partition and then reattach them once moved. SQL will not dynamically update data base paths. Also you may have to tell your other software where its data is. After that has successfully been moved across you should be able to remove the old raid array or reuse.

Should work fine though.

NutrientMS

my bad. Didnt read your initial post correctly. No this wont work. For your phone software it may how ever to keep your SQL data correct, in the outage time you will need to detach your database's then copy the data to the new partition, then change the drive letters, then reattach the database's, Pretty easy really. This will keep the data current as copying live data base's with robocopy can and will cause you problems.

Malli Boppe

ASKER

before copying the the SQL databases. I will stop all the SQL services.Once I finish copying the data with the robocopy change the drive letter I will start the SQl services.

ASKER CERTIFIED SOLUTION

NutrientMS

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION