Unusual error in database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aaron Wolski (anonymous_at_discussions.microsoft.com)
Date: 08/22/04 

Date: Sun, 22 Aug 2004 12:06:30 -0700

I am currently attempting to fix a corrupted exchange
server database for a client, that resulted from a power
failure. After exhausting all other options from the
disaster recovery document, I tried to perform a hard
recovery of the private store.

The process appeared to make steady progress until about
~72% through the repair database table section. Here, it
sat, for over an hour until I cancelled. A backup was
available, albeit dated (don't ask), which was restored in
place. The backup would not mount as well, so I proceeded
with a hard recovery of it, hoping that the damage would
be minimal. This time it hit ~78% before all progress
seemed to stop.

This seemed like too great a coincidence to me that,
taking growth of the database into consideration, the
recovery process was stalling in the same spot. Could
there be something fundamentally wrong with the private
store that prevents recovery while it still allowed normal
operation before the failure?

I did make copies of the data immediately after the
failure and after restore from the backup. The next step
may have to be tech support.

Relevant Pages

  • Re: How can I back up a log-shipped database?
    ... This means that a later log backup from the production database will not just be ... able to add the log records to the log-shipped database, because the transaction log has been ... It's clear I don't understand the whole RECOVERY business. ...
    (microsoft.public.sqlserver.server)
  • Re: Audacity and Gentoo
    ... > What's the UPS, btw? ... Still, a difference system would save a lot of space, unless database ... It would also be useful in case of data recovery as you'd at least be ... > Backup and Point-In-Time Recovery'). ...
    (uk.comp.os.linux)
  • Re: How can I back up a log-shipped database?
    ... When you bring a db out of standby mode, you get the recovery ... log backup onto this, as the log records in that log backup are totally out-of sync with the database you have ... Or MS would need to change SQL Server so it allow us to do a backup of a database in STANDBY mode. ...
    (microsoft.public.sqlserver.server)
  • Re: Shared databases and improving reliability
    ... For me that's one of the major tasks of a database! ... The mere job of data conversion is rather cumbersome for FMP itself ... After recovery the 700 000 records where available ... The backup solution ...
    (comp.databases.filemaker)
  • Re: Oracle: how to demonstrate successful restore?
    ... > We could always backup the database in tape, but we might NEVER get it ... That's called a black hole backup. ... tape could be bad after leaving there for a while. ... Are you sure that the tape is ripe enough for a recovery ...
    (comp.databases.oracle.server)