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

Disavantages of shrinking database

My database is growing bigger and bigger, and I am afraid it will run out of
disk space later on. I would like to shrink it, but I read somewhere that
shrinking is not a good idea if the database is still growing, because it
will slow down adding new records to the database. Would you please confirm
regarding the disadvantages of shrinking the database ? Thank you.you just nailed it on the head.
If you shrink it, the db will have to "AutoGrow" (Or manually grow) at
somepoint,.
this is an expensive operation.
Furthermore, shrinking and growing a db causes fragmentation which can
dramatically effect system performance.
You are far better off planning for more disk capacity asap.
Greg Jackson
PDX, Oregon|||http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...
> My database is growing bigger and bigger, and I am afraid it will run out of
> disk space later on. I would like to shrink it, but I read somewhere that
> shrinking is not a good idea if the database is still growing, because it
> will slow down adding new records to the database. Would you please confirm
> regarding the disadvantages of shrinking the database ? Thank you.
>|||Thank you all for your replies.
If I delete a lot of data from the database, the next time new data need to
be added to the database, will it reuse the space from the old data or will
it keep growing the database ?
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "fniles" <fniles@.pfmail.com> wrote in message
> news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...
>> My database is growing bigger and bigger, and I am afraid it will run out
>> of disk space later on. I would like to shrink it, but I read somewhere
>> that shrinking is not a good idea if the database is still growing,
>> because it will slow down adding new records to the database. Would you
>> please confirm regarding the disadvantages of shrinking the database ?
>> Thank you.|||It depends on how the layout of the data is indexes you have, what you cluster on, what data you
have deleted). In general, the space will be re-used, how long it will take (how much you have to
delete) depends on the details.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:uZzEcTAfFHA.1680@.TK2MSFTNGP09.phx.gbl...
> Thank you all for your replies.
> If I delete a lot of data from the database, the next time new data need to be added to the
> database, will it reuse the space from the old data or will it keep growing the database ?
> Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "fniles" <fniles@.pfmail.com> wrote in message news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...
>> My database is growing bigger and bigger, and I am afraid it will run out of disk space later
>> on. I would like to shrink it, but I read somewhere that shrinking is not a good idea if the
>> database is still growing, because it will slow down adding new records to the database. Would
>> you please confirm regarding the disadvantages of shrinking the database ? Thank you.
>

Disavantages of shrinking database

My database is growing bigger and bigger, and I am afraid it will run out of
disk space later on. I would like to shrink it, but I read somewhere that
shrinking is not a good idea if the database is still growing, because it
will slow down adding new records to the database. Would you please confirm
regarding the disadvantages of shrinking the database ? Thank you.
you just nailed it on the head.
If you shrink it, the db will have to "AutoGrow" (Or manually grow) at
somepoint,.
this is an expensive operation.
Furthermore, shrinking and growing a db causes fragmentation which can
dramatically effect system performance.
You are far better off planning for more disk capacity asap.
Greg Jackson
PDX, Oregon
|||http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...
> My database is growing bigger and bigger, and I am afraid it will run out of
> disk space later on. I would like to shrink it, but I read somewhere that
> shrinking is not a good idea if the database is still growing, because it
> will slow down adding new records to the database. Would you please confirm
> regarding the disadvantages of shrinking the database ? Thank you.
>
|||Thank you all for your replies.
If I delete a lot of data from the database, the next time new data need to
be added to the database, will it reuse the space from the old data or will
it keep growing the database ?
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "fniles" <fniles@.pfmail.com> wrote in message
> news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...
|||It depends on how the layout of the data is indexes you have, what you cluster on, what data you
have deleted). In general, the space will be re-used, how long it will take (how much you have to
delete) depends on the details.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:uZzEcTAfFHA.1680@.TK2MSFTNGP09.phx.gbl...
> Thank you all for your replies.
> If I delete a lot of data from the database, the next time new data need to be added to the
> database, will it reuse the space from the old data or will it keep growing the database ?
> Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...
>

Disavantages of shrinking database

My database is growing bigger and bigger, and I am afraid it will run out of
disk space later on. I would like to shrink it, but I read somewhere that
shrinking is not a good idea if the database is still growing, because it
will slow down adding new records to the database. Would you please confirm
regarding the disadvantages of shrinking the database ? Thank you.you just nailed it on the head.
If you shrink it, the db will have to "AutoGrow" (Or manually grow) at
somepoint,.
this is an expensive operation.
Furthermore, shrinking and growing a db causes fragmentation which can
dramatically effect system performance.
You are far better off planning for more disk capacity asap.
Greg Jackson
PDX, Oregon|||http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl..
.
> My database is growing bigger and bigger, and I am afraid it will run out
of
> disk space later on. I would like to shrink it, but I read somewhere that
> shrinking is not a good idea if the database is still growing, because it
> will slow down adding new records to the database. Would you please confir
m
> regarding the disadvantages of shrinking the database ? Thank you.
>|||Thank you all for your replies.
If I delete a lot of data from the database, the next time new data need to
be added to the database, will it reuse the space from the old data or will
it keep growing the database ?
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "fniles" <fniles@.pfmail.com> wrote in message
> news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...|||It depends on how the layout of the data is indexes you have, what you clus
ter on, what data you
have deleted). In general, the space will be re-used, how long it will take
(how much you have to
delete) depends on the details.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:uZzEcTAfFHA.1680@.TK2MSFTNGP09.phx.gbl...[
vbcol=seagreen]
> Thank you all for your replies.
> If I delete a lot of data from the database, the next time new data need t
o be added to the
> database, will it reuse the space from the old data or will it keep growin
g the database ?
> Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...
>[/vbcol]