The database is in full recovery mode.
The backup schedule is:
Full backup every night at 11PM
transaction log backup every day from 7am to 5 PM
Someone made some mistake at 7PM on Monday but didn't realize until Tuesday morning. How to restore the database back to Monday night 6:59PM?
I restore the full backup using Sunday's...apply all Monday's transaction backup...Can I use Tuesday's transaction backup to restore the database to the point 6:59PM on Monday night?