| Author |
Transaction log not clearing
|
|
| Tom Reis 2006-11-15, 7:14 pm |
| I am running SQL 2000 SP4. I have a database where there is 2GB of
transaction log being used. If I try to back it up and delete inactive
entries it doesn't clear. If I run DBCC CHECKDB on the database it shows no
problem. Any ideas what could be done to clean it out.
| |
| Tibor Karaszi 2006-11-15, 7:14 pm |
| Check for open transactions using DBCC OPENTRAN.
(If you want to *shrink* the file, which isn't the same thing as clearing the file, check out
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/
"Tom Reis" <reistom@cdnet.cod.edu> wrote in message news:%23kXhAgMCHHA.3448@TK2MSFTNGP03.phx.gbl...
>I am running SQL 2000 SP4. I have a database where there is 2GB of transaction log being used. If I
>try to back it up and delete inactive entries it doesn't clear. If I run DBCC CHECKDB on the
>database it shows no problem. Any ideas what could be done to clean it out.
>
| |
|
|
|
| so then we can only assume you actually want to shrink the log file?
if this is the case - without having to re-type how to do achieve this,
check out the link Tibor supplied.
"Tom Reis" <reistom@cdnet.cod.edu> wrote in message
news:uhbLB4MCHHA.4428@TK2MSFTNGP04.phx.gbl...
> Ran the DBCC OPENTRAN. Showed no active transactions.
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote
> in message news:uNX5glMCHHA.3924@TK2MSFTNGP02.phx.gbl...
>
>
|
|
|
|