Post reply

recover database only have log file

  • July 16, 2008 at 3:45 am

    #381722

    Hi all,

    How to recover database only have log file (Recovery mode FULL) and mdf file corrupted

    we have few months back full backup

    Tharindu Dhaneenja.
    MCTS,MCITP(SQL Server),OCA(Oracle)
    http://www.databaseusergroup.com

  • July 16, 2008 at 8:35 am

    #843817

    Do you have the transaction log backups from the time of the last full 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

  • July 16, 2008 at 9:17 am

    #843874

    If the MDF file is corrupted, and you're sure, first make a copy of it and the LDF files immediately. That way someone can help you. If you can run a last transaction log backup (tail backup) do that.

    If you have a full backup, when is it from and what log backups to you physically have now?

  • August 6, 2008 at 5:31 am

    #853725

    restore full with no recovery & log back ups

  • August 7, 2008 at 9:56 pm

    #854904

    My two cents; bcuz I used to have to manage the Disaster Recovery Handbook for my last employer (and this is not just for DB recovery...)

    "Your Data Backup is only as trustworthy as your last test restore. Any data beyond that should be considered suspect.

    And---

    "Your Disaster Recovery model is only as good as your last survived disaster. "

    Not saying you should test restore every day,,, but you should at random intervals test your backups and your recovery models.

Viewing 5 posts - 1 through 4 (of 4 total)

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