Comprehensive data protection for all workloads
Post Reply
mikeely
Expert
Posts: 224
Liked: 69 times
Joined: Nov 07, 2016 7:39 pm
Full Name: Mike Ely
Contact:

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

Post by mikeely »

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.
'If you truly love Veeam, then you should not let us do this :D' --Gostev, in a particularly Blazing Saddles moment
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

Are you sure transaction logs were backed up at least once after the most recent VM backup took place?
mikeely
Expert
Posts: 224
Liked: 69 times
Joined: Nov 07, 2016 7:39 pm
Full Name: Mike Ely
Contact:

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

Post by mikeely »

I think so. Where do the logfiles live? The details pane for log shipping isn't very detailed.
'If you truly love Veeam, then you should not let us do this :D' --Gostev, in a particularly Blazing Saddles moment
mikeely
Expert
Posts: 224
Liked: 69 times
Joined: Nov 07, 2016 7:39 pm
Full Name: Mike Ely
Contact:

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

Post by mikeely »

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.
'If you truly love Veeam, then you should not let us do this :D' --Gostev, in a particularly Blazing Saddles moment
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

Mike, please contact support for a closer look at what's happening. Thanks.
mikeely
Expert
Posts: 224
Liked: 69 times
Joined: Nov 07, 2016 7:39 pm
Full Name: Mike Ely
Contact:

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

Post by mikeely »

Somehow over the weekend the issue ironed itself out. Now I'm seeing the current logs.
'If you truly love Veeam, then you should not let us do this :D' --Gostev, in a particularly Blazing Saddles moment
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

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

Post by foggy »

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

Who is online

Users browsing this forum: Google [Bot], Paul.Loewenkamp and 148 guests