Protecting SQL Server Data
Here’s a quick collection of additional links and resources for folks who followed along with my Protecting SQL Server Data presentation today.
First and foremost (of course) I’ve got a couple of videos for anyone interested in learning more about the basics of backups, recovery, logging, and so on. Likewise, I’ve also got some videos on best practices for when it comes to implementing disaster recovery plans, and a number of how-to videos that will walk you through the process of implementing actual backups and working through restore and recovery operations:
SQL Server Logging Essentials
SQL Server Backup Best Practices
Restoring Databases with SQL Server Management Studio
The Full Series of 15 Free Video Tutorials on SQL Server Backups
Above and beyond the basics, we covered a lot of options and details in our session today – and if you’d like to learn a bit more about options when it comes to making your data more redundant, go ahead and give these links a stab:
Failover Cluster Documentation
SQL Server 2008 Failover Clustering Whitepaper
Denny Cherry's SQL Server 2008 Clustering Articles in SQL Magazine
Log Shipping Overview
Step By Step to Configuring Log Shipping
Log Shipping Fail Over
Log Shipping and Additional Dependencies
Database Mirroring Overview
Providing High Availability with Database Mirroring
Implementing Failover with Database Mirroring
Performance Best Practices for Database Mirroring
Using Database Mirroring AND Log Shipping Together
Combining Log Shipping and Replication
Log Shipping for Reporting Purposes
Think house-boat: Log Shipping is good for HA OR Reporting. Don't try to blend both into same solution.
Books Online Overview
Management of Replication Agents
This is where the BULK of your more ADVANCED performance and configuration options will be.
Great Resource for Replication Troubleshooting
Finally, if you had some questions that weren’t answered during our brief session today, or if you think of some questions in the next few days, feel free to ping me. I’m always happy to help folks out with questions – as it’s a form of marketing and just a general way for me to stay abreast of the kinds of problems organizations are struggling with. So, if you’d like to ask a couple of questions (or if you’d like to talk to me about a potential engagement), make sure to head over to my SQL Server Consulting site or visit my contact page to drop me a line.