|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > Scrink function
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Dan Uhre 2002-08-14, 2:23 am |
| I've recently run out of hd space. I'm trying to scrink all of my dbs, but
the main db just freeze and I'm forced to close it througt task manager. Is
there any limits on free space before running scrink (the transaction log =
13,5Gb, database = 5GB) There's about 1Gb of free space right now. Would it
be a solution to install a new disc, place the backup files on that and run
the scrink function, copy it back and then upgrade my raid.
| |
| Andrew J. Kelly 2002-08-14, 6:23 am |
| Dan,
Try using DBCC SHRINKFILE and shrink the Log file first. That should free
up a lot of room and the log does not need extra space to shrink. Then you
can try using SHRINKFILE on the DB as well. By the way it will take some
time to shrink the DB and it may look like it's frozen but if you watch the
CPU and disk counters you will most likely see lots of activity. These may
help especially the first one as to why your Log got so large in the first
place.:
http://support.microsoft.com/defaul...b;en-us;q110139 Log file
filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
Q256650 INF: How to Shrink the SQL Server 7.0 Transaction Log
Q272318 INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC
SHRINKFILE
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
"Dan Uhre" <danu@lilleheden.com> wrote in message
news:e$5WqS2QCHA.4168@tkmsftngp08...
> I've recently run out of hd space. I'm trying to scrink all of my dbs, but
> the main db just freeze and I'm forced to close it througt task manager.
Is
> there any limits on free space before running scrink (the transaction log
=
> 13,5Gb, database = 5GB) There's about 1Gb of free space right now. Would
it
> be a solution to install a new disc, place the backup files on that and
run
> the scrink function, copy it back and then upgrade my raid.
>
>
|
|
|
|
|