|
Home > Archive > MS SQL Server > November 2006 > CHECKING the TRANSACTION LOG
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 |
CHECKING the TRANSACTION LOG
|
|
| Tom Reis 2006-11-16, 7:12 pm |
| 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.
| |
| Tibor Karaszi 2006-11-16, 7:12 pm |
| 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.gbl...
>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.
>
>
| |
| John Bell 2006-11-16, 7:12 pm |
| 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.
>
>
>
|
|
|
|
|