Technical Article

Transaction Log Can´t Clear

,

When the transaction log is full, sometimes the SQLServer 6.5 and 6.0 does not clear the transactions after dump command. This situation occours because not enough more page to record a end-point for transaction.

exec sp_configure 'allow updates', 1

reconfigure with override
go
update master..sysdatabases
    set category = 1
    where name = 'db_empl'
go

exec sp_repldone 0, 0, NULL, 0, 0, 1

dump tran db_empl with no_log
go
update master..sysdatabases
   set category = 0
   where name = 'db_empl'
go
exec sp_configure 'allow updates', 0

reconfigure with override
go

Rate

5 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating