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

Availability for the Always-On Enterprise

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

Veeam Logoby mikeely » Fri Jan 13, 2017 10:21 pm

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.
Unless otherwise specified, I am asking about something pertaining to Linux. We use Windows as infrequently as possible, and enthusiastically seek ways to reduce that usage further.
mikeely
Enthusiast
 
Posts: 51
Liked: 10 times
Joined: Mon Nov 07, 2016 7:39 pm
Full Name: Mike Ely

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

Veeam Logoby foggy » Fri Jan 13, 2017 10:23 pm

Are you sure transaction logs were backed up at least once after the most recent VM backup took place?
foggy
Veeam Software
 
Posts: 15303
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

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

Veeam Logoby mikeely » Fri Jan 13, 2017 10:41 pm

I think so. Where do the logfiles live? The details pane for log shipping isn't very detailed.
Unless otherwise specified, I am asking about something pertaining to Linux. We use Windows as infrequently as possible, and enthusiastically seek ways to reduce that usage further.
mikeely
Enthusiast
 
Posts: 51
Liked: 10 times
Joined: Mon Nov 07, 2016 7:39 pm
Full Name: Mike Ely

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

Veeam Logoby mikeely » Sat Jan 14, 2017 1:00 am

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.
Unless otherwise specified, I am asking about something pertaining to Linux. We use Windows as infrequently as possible, and enthusiastically seek ways to reduce that usage further.
mikeely
Enthusiast
 
Posts: 51
Liked: 10 times
Joined: Mon Nov 07, 2016 7:39 pm
Full Name: Mike Ely

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

Veeam Logoby foggy » Mon Jan 16, 2017 11:57 am

Mike, please contact support for a closer look at what's happening. Thanks.
foggy
Veeam Software
 
Posts: 15303
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

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

Veeam Logoby mikeely » Mon Jan 16, 2017 5:28 pm

Somehow over the weekend the issue ironed itself out. Now I'm seeing the current logs.
Unless otherwise specified, I am asking about something pertaining to Linux. We use Windows as infrequently as possible, and enthusiastically seek ways to reduce that usage further.
mikeely
Enthusiast
 
Posts: 51
Liked: 10 times
Joined: Mon Nov 07, 2016 7:39 pm
Full Name: Mike Ely

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

Veeam Logoby foggy » Mon Jan 16, 2017 5:40 pm

Good. ANyway feel free to ask them for help in case you see this issue again.
foggy
Veeam Software
 
Posts: 15303
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: No registered users and 1 guest