Post reply

Database Crashed bring back to online?

  • June 1, 2012 at 1:01 am

    #392406

    my backup strategy is

    weekly full backup

    everyday diff backup

    every 1 hour TLog backup

    my database is crashed on wednesday at 3:30PM.

    Now (Saturday) i want to bring back to online state without data loss..

    can anyone suggest me the issue..

    Regards,

    Venkat

  • June 1, 2012 at 1:10 am

    #1495671

    Need more detail. What do you mean by 'crashed'? What's the exact current state of the database? And why are you waiting 3 days before restoring the database?

    Do you have the weekly full backup, the latest diff and all log backups since then available?

    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

  • June 1, 2012 at 1:17 am

    #1495673

    Some one deleted log file of the database.

  • June 1, 2012 at 1:21 am

    #1495677

    Then you may not need to restore at all. See http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    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

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

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