troubleshooting Question

Point in time recovery with database on full and bulk Logged Recovery

Avatar of motioneye
motioneyeFlag for Singapore asked on
Microsoft SQL Server
4 Comments2 Solutions290 ViewsLast Modified:

We have transaction log backups running for every hour which full db backup started at 5:00 AM, if in between we have bulk logged recovery as below can I still retore the full db at 5:00am then retore the log until 11:00 am without any sequence broken ?

5:00 AM full db backups
6:00 AM Tran Log  backups
7:00 AM Tran Log  backups
8:00 AM Tran Log  backups
8:30 AM ---- Change the recovery mode from Full to Bulk Logged
9:00 AM Tran Log  backups
10:00 AM Tran Log  backups ---- Change the recovery mode from  Bulk Logged to Full
11:00 Tran Log  backups
Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros