Posted by Erland Sommarskog on 12/19/06 22:31

gabe101 (gabe101@gmail.com) writes:
> We currently do a full back up every night and no log back-ups. We're
> on 'Simple' recovery model and plan to just restore to the most recent
> full backup during a crisis. We can afford this "luxury" because we're
> a small office with few transactions during the work day. This is why
> I chose to do one more live backup of our company database at the noon
> hour...cutting potential losses by 50% (the small losses that they
> would be).

One alternative you may want to investigate is to do a differntial
backup. That may tax your server less.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]