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.

Assertion failed 50260 page number on page does not match page requested

2 posts in Backup and Recovery Last posting was on 2009-01-19 14:15:54.0Z
John Vai Posted on 2009-01-19 11:45:18.0Z
From: "John Vai" <john_vai@hotmail.com>
Newsgroups: sybase.public.ase.backup+recovery
Subject: Assertion failed 50260 page number on page does not match page requested
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <497467ce$1@forums-1-dub>
Date: 19 Jan 2009 03:45:18 -0800
X-Trace: forums-1-dub 1232365518 10.22.241.152 (19 Jan 2009 03:45:18 -0800)
X-Original-Trace: 19 Jan 2009 03:45:18 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3901
Article PK: 47996

Dera Experts:

I would like to know if there is a way to recover a 5.5 database if i have
no valid transaction log.

i have set up the engine server with truncating the translation log on
checkpoint, and the only thing i have a very old database file and the
corrupted database file and a very old transaction log.

can i recover the database with the current data?

i tried the unload but it keeps saying assertion failed.

thank you


Rob Verschoor [Sybase] Posted on 2009-01-19 14:15:54.0Z
Reply-To: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
From: "Rob Verschoor [Sybase]" <robv@DO.NOT.SPAM.sybase.com.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.backup+recovery
References: <497467ce$1@forums-1-dub>
Subject: Re: Assertion failed 50260 page number on page does not match page requested
Lines: 43
Organization: Sybase Inc
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49748b1a$1@forums-1-dub>
Date: 19 Jan 2009 06:15:54 -0800
X-Trace: forums-1-dub 1232374554 10.22.241.152 (19 Jan 2009 06:15:54 -0800)
X-Original-Trace: 19 Jan 2009 06:15:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3902
Article PK: 47990

I think you're in the wrong newsgroup. Your question sound like SQL Anywhere
but this newsgroup is about ASE.
Try sybase.public.sqlanywhere.general instead....

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"John Vai" <john_vai@hotmail.com> wrote in message
news:497467ce$1@forums-1-dub...
> Dera Experts:
>
> I would like to know if there is a way to recover a 5.5 database if i have
> no valid transaction log.
>
> i have set up the engine server with truncating the translation log on
> checkpoint, and the only thing i have a very old database file and the
> corrupted database file and a very old transaction log.
>
> can i recover the database with the current data?
>
> i tried the unload but it keeps saying assertion failed.
>
> thank you
>