Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Moving a partition

Posted on 2008-09-30
10
Medium Priority
?
308 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 5

Accepted Solution

by:
NutrientMS earned 600 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 400 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
 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

604 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