Vidéos d'aide de Screencast
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

MS SQL Tail-Log backup

Created: 30 Août 2012 • Updated: 31 Août 2012 | 3 comments
l'image des RLeon
Ce problème a été résolu. Voir la solution.

Hi all,

Does Backup Exec 2010/2012 support backing up MS SQL Tail-Logs?

Here are some quick info about Tail-Logs:
http://technet.microsoft.com/en-us/library/ms179314

I understand that Backup Exec could do:
Restore full without recovery > Restore differential without recovery > Restore Transaction logs WITH recovery.

But can it also do this:
Backup Tail-Logs after SQL server crash > Restore full without recovery > Restore differential without recovery > Restore Transaction logs without recovery > Restore Tail-Logs WITH recovery.

(Little irrelevant info: Netbackup could do it.)

Thanks all,

RLeon

Commentaires CommentairesAccéder au dernier commentaire

l'image des RLeon

...Or, am I supposed to:

Restore full without recovery > Restore differential without recovery > Restore Transaction logs without recovery > Tell the SQL admin to complete the recovery using the Tail-Logs

..?

l'image des VJware

BE explicitly does not offer the provision of tail-log backups...(I don't think Netbackup offers this either...I think Netbackup too directs to the MS site for tail-log backups/restores)...

And if you want to perform a tail-log restore, then yes, the above steps would work just fine...

SOLUTION
l'image des RLeon

Thanks for clarifying.
I guess it is only fair to let the SQL admin do half of the remaining work...

About Netbackup, I can assure you that it can backup and restore SQL Tail-Logs.
Please refer to the attached image, extracted from the Netbackup SQL Admin Guide.

Thanks again,

RLeon

nbu sql tail log.jpg