How to recover the database, without allowing any dataloss..?

  • Guys,

    If I don't want any 'data loss' and want to recover the database from Suspect mode, well, how to do it? Moreover, I don't have any 'backup' of the database also...

    Note: DBCC Checkdb () has three options::

    REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST| REPAIR_REBUILD

    None of the option, talk about to retrieve the entire piece of data.

    any suggestion friends?

    Thanks.

  • The only way you can guaranteed recover a suspect database with no data loss is to restore from a backup. Since you have no backup, you are potentially looking at data loss to get it back, no way around that.

    Is this an academic question, or do you have a suspect database without a backup?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • First check whether the database is truly suspect or not.... Can we repair it...??? What errors u r getting when u run DBCC CheckDB???

    Then only we can come to know upto what extent we can recover the daatabase...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply