If I do pragma integrity_check on a database I get:
*** in database main *** On page 8 cell 0: invalid page number 1581 On page 8 at right child: invalid page number 1582 On page 7 cell 0: invalid page number 593 On page 7 cell 1: invalid page number 594 On page 7 cell 2: invalid page number 1171 On page 7 at right child: invalid page number 1712 On page 5 cell 0: invalid page number 372 On page 5 cell 0: invalid page number 551 On page 5 cell 1: invalid page number 737 On page 5 cell 1: invalid page number 552 On page 5 cell 2: invalid page number 1103 On page 5 cell 2: invalid page number 1014 On page 5 cell 3: invalid page number 1466 On page 5 cell 3: invalid page number 1465 On page 5 at right child: invalid page number 1830 Page 9 is never used Page 10 is never used Page 11 is never used Page 12 is never used Page 13 is never used Page 14 is never used Page 15 is never used Page 16 is never used Page 17 is never used Page 18 is never used Page 19 is never used Page 20 is never used Page 21 is never used Page 22 is never used Page 23 is never used Page 24 is never used Page 25 is never used Page 26 is never used Page 27 is never used Page 28 is never used Page 29 is never used Page 30 is never used Page 31 is never used Page 32 is never used SQL error: database disk image is malformed
---
Is there any way to "fix" this (even if some data is lost), or does it just need throwing away and restoring from backup?
(Any ideas what could have caused these types of errors?)
Paul VPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/