Post reply

Bulk log recovery

  • March 23, 2011 at 4:01 am

    #247317

    Hi All,

    I knew point in time restoration not possible when we set bulk log recovery model to database.(Here doing bulk operations)..Some of them mentioned that only minimal information only stored in log that is reason for that...So minimal information(modified information )means what exactly?

    If only minimal information recorded in log means how restoration possible in bulk recovery model...

    can anybody tel me the exact reason

    Thanks In Advance

  • March 23, 2011 at 4:16 am

    #1302356

    Basically it means that for some operations only the page allocations are logged, not the details of the actual row inserts. When a log backup is run, the modified pages, in their entirely, are included in the log backup. Hence a restore to the time of the log backup is possible, but a restore to a point between log backups is not because the log backup only contains the page at the point of the log 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

  • March 23, 2011 at 5:02 am

    #1302376

    Hi Gila,

    Thanks for quick reply..

    But Sorry Still am not clear...what type of data involved in modified pages..?

    Thanks

  • March 23, 2011 at 5:09 am

    #1302381

    I don't understand your question.

    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

  • March 23, 2011 at 5:19 am

    #1302389

    Hi Gila,

    Is Modified pages(located in log) were enough for doing restoration?

    Thanks

  • March 23, 2011 at 5:30 am

    #1302399

    They are enough for doing a restore to the time the log backup was taken, not for doing a point-in-time restore to any random time.

    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 6 posts - 1 through 5 (of 5 total)

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