Home Forums Article Discussions Article Discussions by Author Discuss content posted by Duncan Pryde Point-in-time restore RE: Point-in-time restore

  • February 16, 2011 at 11:40 pm

    #1288052

    Patrick2525 (2/16/2011)

    Well, thanks for the clarification. I was studying for the MCTS exam using 'The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance' by Mark Horninger (2009) which stated it clear as mud:

    The Bulk-Logged recovery model is similar to Full recovery model, except that nonlogged operations are performed as nonlogged. This provides a performance advantage for Bulk-Logged operations. However, if a Bulk-Logged operation has occurred since the last full backup, you will not be able to recover any changes made since the last full backup. The Bulk-Logged recovery model does not support point-in-time recovery.

    I think that line is poorly written, so it can be interpreted incorrectly.

    I think the author meant that if a bulk-logged operation has occurred, you can't do point-in-time recovery.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP