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.
>
