I just read a great e-book on SQL server best practices. It started me thinking about the various meanings of the term ‘practice’. It’s understood that best practices are the actions you perform regularly to get the best possible results.
But ‘practice’ also means ‘the pursuit of a profession’, and that’s the reason we learn and follow IT best practices. Behind every SLA is a professional commitment to the business needs of the organization. When you create your backup and recovery strategy, you align to those business needs. As Dell has put it, you match your backup to your business.
For SQL Server backup and recovery in particular, you should consider the type of data in the databases, and how it’s used. The most obvious questions to answer are the general ones relating to RPO and RTO:
- How much of this data can we afford to lose?
- How long can people be without this data, without impacting the business?
But to create a good backup and recovery strategy for SQL Servers, there are some specific questions you need to ask:
Do you need to restore transactions? To roll forward or cancel non-committed transactions?
The e-book, Best Practices for SQL Server Backups, offers backup and recovery strategies that work for how your business uses your SQL data. It starts with detailed recommendations for good backups in general, then dives into specific issues around database transaction logs, how to choose an appropriate SQL Server recovery model, and best practices for optimizing your SQL Server backups based on your recovery model.
There’s a lot of good info in this e-book, including a reminder to practice restoring from backup:
“Restore the backups on a test server, being sure to verify that you can restore with all the options you would need during various conditions, including both planned and unplanned downtime.”
You’ll learn best practices for backing up your most critical SQL Server data, how to choose and use the right storage hardware, and how you can minimize long-term backup retention costs.
“Practice makes perfect.” So, download your copy of this information-packed e-book today.