Solved

Moving a partition

Posted on 2008-09-30
10
302 Views
Last Modified: 2013-11-14
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?
0
Comment
Question by:Malli Boppe
  • 4
  • 4
  • 2
10 Comments
 
LVL 5

Expert Comment

by:NutrientMS
ID: 22610294
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.
0
 
LVL 5

Expert Comment

by:NutrientMS
ID: 22610308
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.  
0
 
LVL 23

Author Comment

by:Malli Boppe
ID: 22610351
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.
0
 
LVL 5

Accepted Solution

by:
NutrientMS earned 150 total points
ID: 22610494
Should work fine.  one word though, BACKUP :) but if you stop the service and then copy them that would work fine also.  

Gees I should read posts better (kids keeping me awake allnight)

In that case you should be fine.
0
 
LVL 4

Assisted Solution

by:ThorSG1
ThorSG1 earned 100 total points
ID: 22611189
Where is SQL installed?  Is it installed on the C: drive or the D: drive?

If it is installed on C: you will only have to detach the database as NutrientMS stated.  You won't have to take the SQL Services offline.

If it is installed on D: that won't work.  I would recommend taking the SQL services offline.  Backup the entire directory and restore it to the new E: drive.  You should be able to then change the drive letter.  Then restart the SQL Services.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 23

Author Comment

by:Malli Boppe
ID: 22611452
SQL is installed on D drive
0
 
LVL 5

Expert Comment

by:NutrientMS
ID: 22619526
How you suggested will be fine.

Stop SQL
Backup from D:
Restore to E:
Change E: to D:
Start SQL again.
0
 
LVL 23

Author Comment

by:Malli Boppe
ID: 22619878
Thanks guys
I am planing to make the change tonight.Will let you know tommorow.
0
 
LVL 4

Expert Comment

by:ThorSG1
ID: 22625558
So how did your conversion go?
0
 
LVL 23

Author Closing Comment

by:Malli Boppe
ID: 31501793
Thanks Guys
It worked
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

930 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

11 Experts available now in Live!

Get 1:1 Help Now