i have a procedure on sql 6.5 that runs the command dbcc checktable(syslogs)
.
I am migrating this to sql 2000 and am not sure how to replace this. I know
that it is checking the integrity of the log file but what is the equivalent
command in 2000 ?
Thanks in advance.The transaction log isn't a table anymore, so no need to do integrity checki
ng from a table-side
perspective. From SQL7 and onwards, the typical integrity checking performed
is DBCC CHECKDB and
DBCC CHECKCATALOG.
The old CHECKTABLE(syslogs) was often done to correct space usage informatio
n for the transaction
log (if memory serves me). This is not needed for the transaction log, DBCC
SQLPERF(logspace) isn't
dependent on sysindexes anymore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"billu" <billu@.discussions.microsoft.com> wrote in message
news:79BF04DB-287C-466B-9076-A81F32308435@.microsoft.com...
>i have a procedure on sql 6.5 that runs the command dbcc checktable(syslogs
).
> I am migrating this to sql 2000 and am not sure how to replace this. I kno
w
> that it is checking the integrity of the log file but what is the equivale
nt
> command in 2000 ?
> Thanks in advance.
No comments:
Post a Comment