Post reply

point in time restore in bulk logged recovery mode

  • July 22, 2013 at 9:30 am

    #295718

    Hi

    Can some body please suggest that is bulk logged recovery mode database restored to pint in time is any situation..please adives

  • July 22, 2013 at 9:37 am

    #1634530

    Not able to understand! your question is ambiguity.

  • July 22, 2013 at 10:38 am

    #1634573

    Take a read through this: http://www.sqlservercentral.com/articles/Recovery+Model/89664/

    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 22, 2013 at 12:34 pm

    #1634634

    As i understand that , it is not possible in bulk logged recovery mode for point in time restoration. But here i would like to know that ....what will be Log file size, trend of TLog backup file of bulk logged recovery database compared to a full recovery database.

    What will happen if the system crashes in between a bulk operation in bulk logged recovery database..

    Thanks in advance for most valuable reply..:)

  • July 22, 2013 at 2:16 pm

    #1634683

    All answers here: http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2830-bulk_logged-recovery-model/

  • July 22, 2013 at 3:42 pm

    #1634715

    mohan.bndr (7/22/2013)

    As i understand that , it is not possible in bulk logged recovery mode for point in time restoration. But here i would like to know that ....what will be Log file size, trend of TLog backup file of bulk logged recovery database compared to a full recovery database.

    What will happen if the system crashes in between a bulk operation in bulk logged recovery database..

    Thanks in advance for most valuable reply..:)

    Did you read the article I referenced? The one that explains that in a large amount of detail.

    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

  • August 12, 2013 at 1:07 am

    #1640455

    We can restore with full,differential and log backup files

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

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