Red Gate forums :: View topic - Tail Log backup?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Tail Log backup?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dstoltz



Joined: 01 Jul 2010
Posts: 6

PostPosted: Wed Jul 09, 2014 6:57 pm    Post subject: Tail Log backup? Reply with quote

If I have Backup Pro set up (this is an example) to backup a database like this:

- Daily full backup with hourly transaction log backups

And a failure happens at 1:30pm, as I understand it, I would also need to do a "tail log" backup BEFORE restoring the full backup along with all the log backups...

Three Questions:
1) Is this true/correct?
2) And if so, does Backup Pro do this?
3) Does the tail log backup get the the data back from 1pm-1:30pm? (The time between the last transaction log backup and the failure?)

Thanks for any info....trying to improve my understanding of this...
Back to top
View user's profile Send private message
dstoltz



Joined: 01 Jul 2010
Posts: 6

PostPosted: Wed Jul 09, 2014 8:30 pm    Post subject: Think I got it... Reply with quote

I think I answered a few of my questions...

Yes, it would seem the tail log backups up the data between the last trans backup and the failure...

It does NOT appear that Backup Pro can do a tail log backup per se, but a normal trans backup would accomplish the same thing.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Thu Jul 10, 2014 12:37 pm    Post subject: Reply with quote

Thank you for your forum post.

You can perform a backup of transactions in the tail of the transaction log. When you run the Restore Wizard. At step 2 of the wizard, you have the choice to overwrite an existing database or create a new database. When you select the choice to overwrite an existing database you get a dialog that asks how you like to proceed:

Backup the transaction log before proceeding with the restore. This option is the tail backup.

Discard transactions in the tail of the transaction log (WITH REPLACE).

I hope the above answers your question.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
dstoltz



Joined: 01 Jul 2010
Posts: 6

PostPosted: Thu Jul 10, 2014 12:56 pm    Post subject: Thanks! Reply with quote

Eddie - perfect, thank you - yes this answers my question.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group