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 AligbeYou 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 install
ed
> 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
没有评论:
发表评论