Good morning! I have run into this problem today as well. A SQL statement "DELETE FROM <table>" resulted in '[-9028]: System error: BD Bad file'. Now, I have to admit, I am not as familiar with MaxDB/SAP DB as I am with some other systems. When I read the instructions below, "You should build a second system ...", does this mean I need to re-install MaxDB, or just create a new instance within my current installation of MaxDB?
Also, the comment "Your select's do not seam to access this page but one day they will and then the database will stop." - please clarify. If a select tries to access a bad page, will that query fail and return an error, or will the entire database instance go down? Thanks for the excellent product and timely support! Respectfully, Brice Ruth -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 10:25 AM To: Christof Lehmann; [email protected] Subject: RE: Error -24988 sql error -9026 System error: BD Bad datapage 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
