Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

How can I extend my Data Drive?

Hello,

I have a server we use for a demo database. I have two drives and I dont think I have any raid configured.

C:\ OS
T:\ Demo Database

Well my T:\ drive is full and I inserted another drive and I'd like to extend T:\ with new drive.

See Picture below.
 Demo
0
Jaime Campos
Asked:
Jaime Campos
3 Solutions
 
BxozCommented:
The only way to do that it's to make a raid0 between the disk T and E:
But careful raid0 has no redundancy one of this disk fail you loose all your data.

I think it's more simple if you can to move one of your data base on the new partition.
0
 
Richard2k4Commented:
actually through windows you can select your T drive and select expand.  You should be able to choose the newly inserted drive if there is nothing on it.
0
 
Richard2k4Commented:
Replace expand with Span....sorry
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Jaime CamposAuthor Commented:
How do I make a raid 0 between disk T and E? I have data that already resides on T and I do not want to lose it. The redundancy shouldn't be an issue as I dont have any reduncy currently, I just need to extend.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
A RAID 0 is not necessary, but frankly, doing what you're doing is NOT recommended.

What you COULD do is convert Disk 1 and Disk 2 to Dynamic, then span/extend the partition to the new drive (The new drive should NOT be partitioned).

Dynamic disks are a lot more difficult to recover data from and a spanned/extended disk even more so.  I would say a better solution is to migrate to newer, larger drives AND/OR migrate to a RAID 5 (which means buying one more drive; I don't like RAID 5, but it's better than converting to dynamic in my opinion).
0
 
Richard2k4Commented:
Same as Bxoz said about the Raid0, you will have not redundancy here either.
0
 
Jaime CamposAuthor Commented:
Richard2k4,

How do I select Span? I didn't see it.

Thanks,

Nimdatx
0
 
Richard2k4Commented:
Like leew said, the new drive you inserted cannot have a partition on it.
0
 
Jaime CamposAuthor Commented:
If I convert to Dynamic, will I lose my current data? This server is a demo server and not in production. it's used for training purposes. I currently have only two drives, so I don't think I have any raid configured. i understand the risk, thanks. I need to ensure I do not lose my current data when I extend.
0
 
Jaime CamposAuthor Commented:
I won't partition as it's going to be one big DB/data drive. What are the proper steps, so I don't lose my current data and successfully expand?

Thanks so much.

Nimdatx
0
 
Richard2k4Commented:
normally no data lost will occur.  I suggest you read this just to make sure though.

http://technet.microsoft.com/en-us/library/cc737437%28WS.10%29.aspx

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now