Recover data from corrupt DB

Discussion in 'microsoft.public.sqlserver.server' started by John, Dec 6, 2006.

  1. John

    John Guest

    Hi all:

    I have MSCRM running in a VPC setup, so since I had 4 backup copies of the
    VHD files, I never backed up the DBs themselves. Now for some reason all of
    the images have an error in the MSCRM Metabase database, and I cannot
    recover it. I tried this:

    1. alter database Adventure_Works_Cycle_METABASE set emergency
    2. sp_dboption Adventure_Works_Cycle_METABASE, single, true
    3. dbcc checkdb (Adventure_Works_Cycle_METABASE, repair_allow_data_loss)
    4. sp_dboption Adventure_Works_Cycle_METABASE, single, false

    Which got the DB back online, but it dumped a bunch of necessary data and
    broke MSCRM.

    Can anyone make any suggestions as to how I can save the data? The metabase
    tracks customizations to MSCRM, so if I lose it I'll lose all of my work.

    Thanks in advance for any and all help.

    John, Dec 6, 2006
    1. Advertisements

  2. John

    Uri Dimant Guest

    1. Advertisements

  3. John

    John Guest

    John, Dec 7, 2006
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.