|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > dbcc shrinkfile
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]
|
|
|
| I'm trying to shrink my log file.. its 6gb. Ive shrunk the db and
everything else, but the log file will not shrink.
i read through the bol about it... I did a backup on the log, but it still
will not clear out.
Also, when i look at the properties on the database, it shows 7gb used, and
5gb available.. the only file with that much space is the log.
I've also tried using the truncateonly option.. still no go..
This is the output in SQA.
dbid FILEID currentsize minimum size usedpages estimatedpages
5 2 709440 128 709440
128
Thanks.
| |
| Uri Dimant 2002-11-21, 1:23 am |
| PCH
BACKUP LOF FILE WITH TRUNCATE_ ONLY
After backup log file you should notice that phisycal size og log file has
been reduced
May active part of the log is located at the end of physical file.Physical
shrining can only take place from the end of log file ,and active part is
never shrinkable
PCH <pch12@hotmail.com> wrote in message
news:#HqJ$pPkCHA.2816@tkmsftngp11...
> I'm trying to shrink my log file.. its 6gb. Ive shrunk the db and
> everything else, but the log file will not shrink.
>
> i read through the bol about it... I did a backup on the log, but it
still
> will not clear out.
>
> Also, when i look at the properties on the database, it shows 7gb used,
and
> 5gb available.. the only file with that much space is the log.
>
> I've also tried using the truncateonly option.. still no go..
>
> This is the output in SQA.
>
> dbid FILEID currentsize minimum size usedpages
estimatedpages
> 5 2 709440 128 709440
> 128
>
>
> Thanks.
>
>
|
|
|
|
|