December 19, 2002 at 6:31 am
(Test sql server 7 server sp4)
I have a restored database which fails the checkdb even with repair_allow_data_loss with the following error
Buffer 0x1421b280, allocation page (1:2528), in database 'irdb_uat' is not in allocation buffer pool in PSS (process status structure). Contact Technical Support.
A checkdb was run after the first backup was taken and was fine.
Anyone got any further info on this error?
Steven
December 19, 2002 at 9:54 am
No info, but with a buffer problem like this, I'd call PSS. Perhaps take another backup, try to BCP out the data in the table, drop, rebuild the table, then bcp in.
Steve Jones
December 19, 2002 at 10:16 am
I played around with the database, prior to scheduling another restoring of different days backup tonight (that hopefully that will be okay). There were lots of errors on lots of tables for some reason.
I tried a dbcc checktable on one of the problem tables, and that failed as well. I couldn't even drop the clustered index (or even drop the table itself) but I could run a 'select into' to get the data out.
Its a test db (not production), but time to schedule some backup/restore tests in the new year I think.
Steven
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply