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 > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
