•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 402,443 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,944 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 2997 | Replies: 2
![]() |
•
•
Join Date: Nov 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
I run MS SQL 2000, database is growing and my concern is the hard drive will soon run out of disk space. i wonder if i can add a new hard drive and tell SQL there is more space. my question is how i can combine the two hard disks and make SQL thinks it is the same disk. any input or help would be appricated.
Hello,
This is an operating systems question. You might find a better response in that forum.
You will want to first backup your data after closing the database.
Then, depending what version of Windows Server you are running, you will need to span the volume, or you will need to remove the present volume, and replace it with a larger drive. Remember that disks here are different than volumes.
In the windows world, we often think of C: being a disk... it is not... it is a partition on a disk. We can take the same disk, and make a D: or an E: or any other letter that is open.
Windows makes it possible to make a single drive letter span across multiple disks. Of course, you need to think about fault tolerance, and how important it is to your setup. If you cannot afford to be down, then you will need a stronger solution than simply spanning multiple disks. The more disks involved, the more room for failure.
In my opinion, without knowing more of your system requirements and use characteristics, I would at least be looking at a RAID 5 or a larger single drive. If you have other means of fault tolerance, then you can go ahead and look at windows spanning too.
Note also that Windows is not the only OS that can span... linux can too.
Christian
This is an operating systems question. You might find a better response in that forum.
You will want to first backup your data after closing the database.
Then, depending what version of Windows Server you are running, you will need to span the volume, or you will need to remove the present volume, and replace it with a larger drive. Remember that disks here are different than volumes.
In the windows world, we often think of C: being a disk... it is not... it is a partition on a disk. We can take the same disk, and make a D: or an E: or any other letter that is open.
Windows makes it possible to make a single drive letter span across multiple disks. Of course, you need to think about fault tolerance, and how important it is to your setup. If you cannot afford to be down, then you will need a stronger solution than simply spanning multiple disks. The more disks involved, the more room for failure.
In my opinion, without knowing more of your system requirements and use characteristics, I would at least be looking at a RAID 5 or a larger single drive. If you have other means of fault tolerance, then you can go ahead and look at windows spanning too.
Note also that Windows is not the only OS that can span... linux can too.
Christian
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 31
•
•
•
•
Originally Posted by broncos88
I run MS SQL 2000, database is growing and my concern is the hard drive will soon run out of disk space. i wonder if i can add a new hard drive and tell SQL there is more space. my question is how i can combine the two hard disks and make SQL thinks it is the same disk. any input or help would be appricated.
I don't think you need to implement raid to solve this issue (it would do, albeit expensively), adding a new hard disk and creating new filegroups on it would be sufficient. Creating file groups and allocating resources to them requires a good understanding of your database structure.
these links may be of use
![]() |
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- i want my Hard disk space back!!! (Windows 9x / Me)
- Windows XP Hard Disk Profile (Windows NT / 2000 / XP / 2003)
- Hard drive space reducing. Its frightning!! (Storage)
- Hard drive space reducing. Its frightning!! (Storage)
- HDD disk space incorrect (Storage)
- Hard Disk Space (Windows NT / 2000 / XP / 2003)
Other Threads in the MS SQL Forum
- Previous Thread: Help with a stored procedure
- Next Thread: user creation using msde



Linear Mode