Restore script and has_bulk_logged_data = 1


So, I read an article by Kimberly Tripp that gave me a better understanding of bulk log mode and transaction log backups (http://www.sqlmag.com/article/high-availability/the-best-place-for-bulk_logged). With this new knowledge in mind, the restore script needs to change how it views has_bulk_logged_data and the changes it requires on the recovery path (ie, recovery path is not broken; only point-in-time recovery during the TLs with bulk log data).


gephartr wrote Jun 7, 2012 at 9:01 PM

I have not yet run into any examples internally to review with this. And we haven't really been doing any point-in-time recoveries on-site; it is always at minimum a transaction log backup that we restore to. I haven't forgot about this - but it has not yet had any priority.

wrote Feb 13, 2013 at 5:40 PM