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.
>
>
No comments:
Post a Comment