Post reply

Bulk-Recovery-Model

  • November 8, 2011 at 5:06 am

    #390790

    Hi All,

    As far as i know when we set bulk recovery model to database data will minimally recorded in transaction log..minimal information means what exactly?

    Point in time restoration ,point of failure restoration not possible in bulk recovery model becoz of minimal information..(doing bulk operations)

    If so how can normal recovery posible in bulk recovery model as it only kept minimal inforamation?

    Could anyone tel me what exactly going in this operation..Thanks in advance

    Rekha

  • November 8, 2011 at 5:13 am

    #1404377

    http://msdn.microsoft.com/en-us/library/ms189275.aspx

    http://msdn.microsoft.com/en-us/library/ms191244.aspx

    http://msdn.microsoft.com/en-us/library/ms186229.aspx

    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

  • November 8, 2011 at 5:29 am

    #1404388

    Hi gila..Thanks for reply(very helpful sites)

    I had better if u will give our own words in short..

    Thanks

  • November 8, 2011 at 5:34 am

    #1404391

    It's not entirely clear what you are asking

    Point in time restoration ,point of failure restoration not possible in bulk recovery model becoz of minimal information..(doing bulk operations)

    If so how can normal recovery posible in bulk recovery model as it only kept minimal inforamation?

    you seem to be stating that point in time recevery is not possible in bulk recovery mode, then go on to ask how we can do recovery in bulk mode..

    I may be mis-reading this though..

  • November 8, 2011 at 5:40 am

    #1404396

    I mean to ask that normal recovery not point in time

  • November 8, 2011 at 5:44 am

    #1404399

    Both crash recovery and log restores work much the same way in bulk-logged as in full. The only difference is that STOPAT can't be used when the specified time is within a log backup that contains minimally logged operations.

    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

  • November 8, 2011 at 5:45 am

    #1404401

    gsuvarnarekha (11/8/2011)

    I had better if u will give our own words in short..

    What, you want me to rewrite or summarise Books Online?

    Read through the BoL pages, if you have specific questions after that please ask.

    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

  • November 8, 2011 at 5:45 am

    #1404402

    what am asking is if minimal information stored in t-log means how can we recover the data when we set database as bulk recovery...

    hope u understand..

    Thanks

  • November 8, 2011 at 5:53 am

    #1404412

    gsuvarnarekha (11/8/2011)

    what am asking is if minimal information stored in t-log means how can we recover the data when we set database as bulk recovery...

    Did you read those articles?

    What do you mean by recover? Restore log backup? Recover data manually?

    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 9 posts - 1 through 8 (of 8 total)

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