No enough space

Sooner or later my database will be out of space
(1.2G)...what shall i do to avoid this thing to happen ?Assiciate another filegroup to your database and restric auto growth in the
current file group ... SQL will automatically start using the filegroup
cerated on a different HDD where you have unlimited space ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Ynna" <ynna0319@.hotmail.com> wrote in message
news:06a501c3a413$59b76170$a401280a@.phx.gbl...
> Sooner or later my database will be out of space
> (1.2G)...what shall i do to avoid this thing to happen ?|||SQL Server will not automatically start using that filegroup... Only if you
place the objects explicitly on that filegroup.
However, adding a file (for the same filegroup) on the second disk will
achieve this.
--
Tibor Karaszi
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eBDZgvCpDHA.2304@.TK2MSFTNGP11.phx.gbl...
> Assiciate another filegroup to your database and restric auto growth in
the
> current file group ... SQL will automatically start using the filegroup
> cerated on a different HDD where you have unlimited space ...
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
> "Ynna" <ynna0319@.hotmail.com> wrote in message
> news:06a501c3a413$59b76170$a401280a@.phx.gbl...
> > Sooner or later my database will be out of space
> > (1.2G)...what shall i do to avoid this thing to happen ?
>