Post reply

Will there be any data loss?

  • December 12, 2016 at 6:41 am

    #332677

    Good Morning Experts,

    One of my database is in suspect state. The database's ldf file is damaged but mdf file is available. Can we run the emergency/repair_allow_data_loss command to get it out of the suspect state. Will there be any data loss?

  • December 12, 2016 at 6:43 am

    #1917362

    Maybe.

    Maybe.

    Got a good 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

  • December 12, 2016 at 2:30 pm

    #1917483

    Hi Gail,

    The mdf file is available. So there shouldnt be any data loss, correct?

  • December 14, 2016 at 8:29 am

    #1917910

    Incorrect. As Gail says, have you got a backup?

  • December 14, 2016 at 8:39 am

    #1917918

    coolchaitu (12/12/2016)

    Hi Gail,

    The mdf file is available. So there shouldnt be any data loss, correct?

    The pages in memory are not hardened to the physical data file immediately. But the log file will track every changes to guarantee that your database is consistent.

    So restoring from a backup is the best idea.

    Mean while look through all your logs to find out what happened

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 15, 2016 at 9:05 pm

    This was removed by the editor as SPAM

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

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