Disk space Issues

Good day,
I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
database. Is there a way to chanel the incoming data to an already installed
40Gig disk on thesame system?
Michael Aligbe
You could back up your database, drop it, and then restore it with the "WITH
MOVE" option. This would allow you to place your ldf and/or mdf files on a
different drive.
The other option would be to add filegroups to your database and move some
of your data to those new filegroups. This might be a little more involved
than option one however.
"Myk" wrote:

> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe
|||Another way is to sp_detach_db dbname,
copy the mdf file to the other hard drive, the
sp_attach_db dbname, mdffilename, logfilename
This would be quicker than backing up and restoring
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Myk" <Myk@.discussions.microsoft.com> wrote in message
news:00085AD1-BF75-4066-9C12-3D2BAF27DB14@.microsoft.com...
> Good day,
> I installed sql server 2000 on a 10Gig disk. Now i have a fast growing
> database. Is there a way to chanel the incoming data to an already
installed
> 40Gig disk on thesame system?
> --
> Michael Aligbe
sql