|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Transaction log file size
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]
| Author |
Transaction log file size
|
|
| Gustavo Jacob 2002-10-31, 6:23 am |
| Hi there,
I was having serious performance problem with my server and i changed some
settings. One of then was the data and log file sizes, they were auto grow
and now i've set file sizes.
My problem is when i back up my trasaction log, its not freenig all the
space of he file. Is it normal? shoudn't it be 100% free?
If not, what can i do to free this space?
Tanks
| |
| Tibor Karaszi 2002-10-31, 6:23 am |
| It is generally close to 100% free. Perhaps you have open transactions? See DBCC OPENTRAN.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Gustavo Jacob" <gustavo@websee.com.br> wrote in message news:emKmHNNgCHA.1720@tkmsftngp11...
> Hi there,
>
> I was having serious performance problem with my server and i changed some
> settings. One of then was the data and log file sizes, they were auto grow
> and now i've set file sizes.
>
> My problem is when i back up my trasaction log, its not freenig all the
> space of he file. Is it normal? shoudn't it be 100% free?
>
> If not, what can i do to free this space?
>
> Tanks
>
>
|
|
|
|
|