CHECKING the TRANSACTION LOG

I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
2000 Server. Is there a equivalent command or procedure. Thanks.What is it in the transaction log that you want to check?
For 7.0 and 2000, DBCC CHECKDB and CHECKCATALOG covers integrity checks for
a database.
For 2005, you don't need CHECKCATALOG.
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:OsLvRLaCHHA.4908@.TK2MSFTNGP03.phx.g
bl...
>I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>|||Hi Tom
Because log files are separate physical files this command is redundant. If
you want to look at the space used in the log file try DBCC SQLPERF
(logspace) http://msdn2.microsoft.com/en-us/library/aa258819(SQL.80).aspx.
For other database consistency checks DBCC CHECKDB, DBCC CHECKTABLE, DBCC
CHECKALLOC...
John
"Tom Reis" wrote:

> I am running SLQ 2000 SP4. I used to use the DBCC CHECKTABLE (syslogs) to
> check the transaction log on a SQL 6.5 server. This doesn't work on a SQL
> 2000 Server. Is there a equivalent command or procedure. Thanks.
>
>