JacekO (11/9/2009)
One of the biggest advantages of Full recovery mode is the ability to perform 'point-in-time' restores.
My mileage varies here. For me unplanned server restarts are the big one. Having a customer call to say that the cleaning person unplugged the SQL server box to use the vacuum, again, and there was no data loss is kind of a big thing. The point-in-time thing can come close if you restore you last full and then the differentials up to the point in time. How frequent are your backups? Is a full every day and logs every 15 minutes enough? Is one per minute way too much?
Here is a question for someone who has the time: Can I run a query that shows if there is any un-backed-up changes in my database?
ATBCharles Kincaid