|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Tom Reis" <reis***@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. > > 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 Show quoteHide quote "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. > > >  
Other interesting topics
except keyword
database file does not auto grow Drop table , procedure Problems limited permissions on test server for developers Spid checker query help Low Disk Space Delete records in a table with 15 dependencies how to remove the sql server registry mess? Dynamic SQL or Table Variables?? Installed SQL2000 SP4 successfully but still shows RTM as installe |
|||||||||||||||||||||||
