Home Forums SQL Server 7,2000 Backups Log Shipping - Do we still do Full Backups RE: Log Shipping - Do we still do Full Backups

  • Always back up your databases daily no matter what else you do. Say for example Monday morning you notice the log ship server had a problem with log shipping over the weekend and no trans logs have been applied, and due to the fact that they are older than your max retention period they have been deleted. Then your main production server dies. You've just lost the entire weekends data.

     



    Shamless self promotion - read my blog http://sirsql.net