(someone@js.com) writes:
Wrong question. The right question is: if the database goes belly-up
how much can you afford to lose? Is it OK to restore the most recent
backups (you are taking backups, are not you?), or are you content with
losing recent updates? And this is not meant to be a rhethoric question,
but a real one that you need to ask yourself. Full recovery will help
you reduce data-loss in case of a disaster. But it comes with a cost, as
it incurs more management.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx