Can I still recover this database : Only have the MDF file, no LDF file ?

Discussion in 'microsoft.public.sqlserver.server' started by cpchan, Nov 4, 2007.

  1. cpchan

    cpchan Guest

    Dear all,

    If a database was corrupted (due to whatever reasons) and lost its LDF files
    but only had its MDF files, can I still recover it ?

    How ?

    Please tell me, thanks.
    cpchan, Nov 4, 2007
    1. Advertisements

  2. cpchan

    Ben Nevarez Guest


    If you have database backups then restore from these backups instead.

    The problem I see with using only the mdf file is that the missing ldf files
    may have information to rollback or roll forward transactions in order to
    leave the database in a consistent state.

    Ben Nevarez
    Senior Database Administrator
    AIG SunAmerica
    Ben Nevarez, Nov 4, 2007
    1. Advertisements

  3. cpchan

    Uri Dimant Guest

    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.