Can SQL Server be rolled back to tlogs AFTER last backup?

mikeely · Post by **mikeely** » Jan 13, 2017 10:21 pm this post

Right now all I can see are point in time restores from before the last regular backup. I'm wondering if/how one might restore to transaction logs shipped after the most recent backup. Thanks.

Post by **foggy** » Jan 13, 2017 10:23 pm this post

Are you sure transaction logs were backed up at least once after the most recent VM backup took place?

mikeely · Post by **mikeely** » Jan 13, 2017 10:41 pm this post

I think so. Where do the logfiles live? The details pane for log shipping isn't very detailed.

mikeely · Post by **mikeely** » Jan 14, 2017 1:00 am this post

OK, I've verified that the backup server is receiving the log shipments both from watching the logship job on the console and by examining the timestamp in the backup repository. For some reason though the log diffs aren't showing up as an available option in the point-in-time restore, only logs shipped prior to last backup.

Post by **foggy** » Jan 16, 2017 11:57 am this post

Mike, please contact support for a closer look at what's happening. Thanks.

mikeely · Post by **mikeely** » Jan 16, 2017 5:28 pm this post

Somehow over the weekend the issue ironed itself out. Now I'm seeing the current logs.

Post by **foggy** » Jan 16, 2017 5:40 pm this post

Good. ANyway feel free to ask them for help in case you see this issue again.

R&D Forums

Can SQL Server be rolled back to tlogs AFTER last backup?

Re: Can SQL Server be rolled back to tlogs AFTER last backup

Re: Can SQL Server be rolled back to tlogs AFTER last backup

Re: Can SQL Server be rolled back to tlogs AFTER last backup

Re: Can SQL Server be rolled back to tlogs AFTER last backup

Re: Can SQL Server be rolled back to tlogs AFTER last backup

Re: Can SQL Server be rolled back to tlogs AFTER last backup

Who is online