Home Forums SQL Server 2005 Backups tail log backup RE: tail log backup
george sibbald
SSC Guru
Points: 104210
More actions
July 3, 2013 at 1:42 pm
#1629652
you would use the norecovery option on a log backup when you want to swap primary and secondary roles in a logshipping set up without needing to reinitialise from a full backup.
---------------------------------------------------------------------