• DugyC (2/16/2011)


    Having not used Bulk options, I managed to do enough digging to find out it was a conditional yes, just chose the wrong one. Thought you would be okay as long as there was no bulk operations since last full backup.

    I guess not :ermm:

    You would indeed be ok, but the answer said "Yes, but only if.." which I intended to mean that if there had been no bulk operations since the last full backup you would be ok, but otherwise not.

    I was thinking of a situation where you might have multiple log backups since the last full backup, several of which might contain bulk operations. As long as the log backup you want to restore to a point in time with doesn't have any, you can restore to that particular point in time. Of course, if none of them have any bulk operations in them you can use any of them to restore to a point in time.

    I apologise for any confusion caused - but as you can imagine, wording something to be completely unambiguous is not as easy as it seems!

    Thanks for the feedback

    Duncan