Hello Uwe, Indeed, recovering the database on a second system doesn't work. I have a complete backup, an autolog file and a logfile. I start revoring with db_activate RECOVER DATA_REC DATA_REC is a medium, which specifies a pipe. I get an OK with Returncode 0 recover_start log_b log_b is also a pipe and I do cat autolog_.003 > pipe I get an OK with Returncode 8020 recover_start or recover_replace lastlog lastlog is a medium with a filename I receive an ERR -24988 ERR_SQL: sql error -8888 connection broken new state 4
With the command db_restartinfo I find out, that the database reads about 1000 pages from the last logfile. Am Donnerstag, den 13.01.2005, 17:24 +0100 schrieb Hahn, Uwe: > Hello Christoph, > > BAD PAGE means that you have corrupted data pages in the system. > Your select's do not seam to access this page but one day they will > and then the database will stop. > > You should build a second system with an older data backup of your > original database. > This second system you should check with "CHECK DATA EXTENDED". > If no errors occur you can use this older data backup again plus your > log backups > from the original system and build up a shadow system. > If errors occur you can use the next older complete data backup. > If you do not have an older correct data backup you have to determine > the table to which > the bad page belongs. You can do this with CHECK DATA and SEL FROM > ROOTS. > > Kind regards > Uwe > > > >-----Original Message----- > >From: Christof Lehmann [mailto:[EMAIL PROTECTED] > >Sent: Thursday, January 13, 2005 5:03 PM > >To: [email protected] > >Subject: Error -24988 sql error -9026 System error: BD Bad datapage > > > > > >Hello, > > > >When I backup the database (incremental or complete), I always get the > >error message > >-24988 sql error -9026 System error: BD Bad datapage > > > >I can stop and start the database. User can connect to the database and > >do sql statements (insert,delete,update > >and select). > > > >What do the message mean? > >What should I do? > >How can I get a complete backup? > >Can I repare the database? > > > >Thanks for answers > > > > > >Christof Lehmann > > > >_______________________________________________________________ > >_________ > > > >eXPertmedia GmbH > > > > > >Chopinstr. 4 > >0341 960 50 93 > >04103 Leipzig > >0341 960 50 92 > > > > > > > > Christof Lehmann ________________________________________________________________________ eXPertmedia GmbH Chopinstr. 4 0341 960 50 93 04103 Leipzig 0341 960 50 92
