Home Forums SQL Server 2005 Backups SQL Server Backups & Maintenance - Best Practices RE: SQL Server Backups & Maintenance - Best Practices

  • Hi,

    The best way of thinking about your backups is as a restore strategy. If you "lost" the database, how long would you have to bring it back online and what would be the acceptable level of data loss (if any)?

    With a maintenance strategy it really depends. How long does it take for your indexes to become fragmented? Are you seeing poor performance due to invalid statistics?

    Sorry to be so vague, but it really does depend on the system

    Andrew