Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

URGENT : Syslogs table corrupt error #2518.

2 posts in Backup and Recovery Last posting was on 2001-03-15 22:34:40.0Z
Archana Posted on 2001-03-15 16:28:24.0Z
From: Archana
Date: Thu, 15 Mar 2001 11:28:24 -0500
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: URGENT : Syslogs table corrupt error #2518.
Message-ID: <DFF72CD6EA269CB0005A7DDB85256A10.005A7DED85256A10@webforums>
Lines: 17
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:395
Article PK: 1060913

Hello All,

I had run Database Diagnostics and the 3 commands on our production
machine:
dbcc checkdb,
dbcc checkalloc,
dbcc checkcatalog

The first 2 commands ran fine, but the dbcc checkcatalog gave me ERROR #
2518.
The error is explained as "DATABASE CORRUPT : Incorrect last checkpoint in
syslogs"

I ran the same command again last night, with the same error.

Please help...

Thanks,
Archana.


Anthony Mandic <amandic Posted on 2001-03-15 22:34:40.0Z
Date: Fri, 16 Mar 2001 09:34:40 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: URGENT : Syslogs table corrupt error #2518.
References: <DFF72CD6EA269CB0005A7DDB85256A10.005A7DED85256A10@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <GTH6JJarAHA.53@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 19
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:393
Article PK: 1060912


Archana wrote:

> I had run Database Diagnostics and the 3 commands on our production
> machine:
> dbcc checkdb,
> dbcc checkalloc,
> dbcc checkcatalog
>
> The first 2 commands ran fine, but the dbcc checkcatalog gave me ERROR #
> 2518.
> The error is explained as "DATABASE CORRUPT : Incorrect last checkpoint in
> syslogs"
>
> I ran the same command again last night, with the same error.

Syslogs is the transaction log. It would be common to see errors
if the database is in use and transactions occurring while the
dbcc's are running. There is a trace flag to turn off checking
in syslogs or you can get users off and switch the database to
single user mode (which isn't always practical).

-am © 2001