|
Home > Archive > MS SQL Data Warehousing > February 2006 > Datafile Full
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]
|
|
| JackCool 2006-02-04, 11:23 am |
| Hi NG,
We have a datafile on drive d: and the log file on drive e: and now the
problem is drive d: is running out of space. We are planning to buy a new
hardisk drive f: what should I do next after we install the new hardisk?
Should I create a new datafile and include that in the primary filegroup and
set the new datafile as default. Is that all I need to do?
Thank you in advance.
| |
|
| its 1 option, yes.
just disable the file growth option for the first file (the one on the d:)
you can also create a new file group and move some tables from the primary
file group to the new one.
"JackCool" <jackcool@yahoo.com> wrote in message
news:upMbY3aKGHA.1676@TK2MSFTNGP09.phx.gbl...
> Hi NG,
>
> We have a datafile on drive d: and the log file on drive e: and now the
> problem is drive d: is running out of space. We are planning to buy a new
> hardisk drive f: what should I do next after we install the new hardisk?
>
> Should I create a new datafile and include that in the primary filegroup
> and set the new datafile as default. Is that all I need to do?
>
> Thank you in advance.
>
|
|
|
|
|