troubleshooting Question

point in time restore in SQL server

Avatar of marrowyung
marrowyung asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
26 Comments2 Solutions197 ViewsLast Modified:

right now we have situtation that we tried to do point in time restore, we do transaction log backup every 15 minutes and full backup on sunday only at 9:00 PM, diff backup from mon to sat at 9:00 PM. assume that we have log backup at 9:15 PM, how can I restore the DB up to 9:20PM as the T log backup hasn't been done yet?

also if the backup run start from 9:00 p.m. to 9:30 p.m., it only backup everything snapshoted at 9:00 PM but not 9:01 PM,right?
Vitor Montalvão
IT Engineer
Join our community to see this answer!
Unlock 2 Answers and 26 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 26 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