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.
     
    John, Dec 6, 2006
    #1
    1. Advertisements

  2. John

    Uri Dimant Guest

    1. Advertisements

  3. John

    John Guest

    John, Dec 7, 2006
    #3
    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.