|
Home > Archive > MS SQL Server > September 2005 > Disk space getting low
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Disk space getting low
|
|
| Stephen Russell 2005-09-06, 1:23 pm |
| I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
How do I get the 2 databases to use drive D in addition to drive E for data?
I have 50 gig volume for E and I have about 9 gig free as of now. D has
only consumed 1 gig and free is 34 gig.
TIA
__Stephen
| |
| Tibor Karaszi 2005-09-06, 1:23 pm |
| Pre-allocate storage for the database files as desired. If you need to shrink one of the file (so
that data will be pushed to the other file), you can do it using DBCC SHRINKFILE. It will take a
while for a lot of data, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Stephen Russell" < srussell@transaction
graphics.com> wrote in message
news:ugcOCCvsFHA.3040@TK2MSFTNGP14.phx.gbl...
>I have 3 disk volumes on my server. C, D, E. C=System, D=Logs, E= Data
>
> How do I get the 2 databases to use drive D in addition to drive E for data? I have 50 gig volume
> for E and I have about 9 gig free as of now. D has only consumed 1 gig and free is 34 gig.
>
> TIA
>
> __Stephen
>
>
>
|
|
|
|
|