• 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