Recover structure from corrupt .MDF?

Discussion in 'microsoft.public.sqlserver.server' started by James, May 19, 2006.

  1. James

    James Guest

    Hi,

    I have a corrupt .mdf file and all I want to do is get the stored procedures
    & table structure out of the file. Is this possible? (I do not have a
    backup ).

    cheers

    James
     
    James, May 19, 2006
    #1
    1. Advertisements

  2. James

    BDB Guest

    That depends on the level of corruption. As long as the procedures weren't
    encrypted, they are stored in the MDF file as text and may be fished out.
    The tables are another story.
     
    BDB, May 19, 2006
    #2
    1. Advertisements

  3. James

    James Guest

    You are a bl**dy star.....I'm so stupid, I should have thought to open the
    file as a text file. Thank you so much!!!

    James
     
    James, May 19, 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.