Power Up with SQL Server: SQL Server High Availability
Here's a list of additional resources for attendees of the SQL Server High Availability session from the Power Up with SQL Server event.
Feel free to contact me if you're looking for a specific resource, or had additional questions that weren't answered in our session.
Decreasing Down Time
SQL Server Enterprise Edition
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Partial Database Availability
http://sqlcat.com/whitepapers/archive/2007/11/21/partial-database-availability.aspx
Moving Logins for Log Shipping and other HA needs
http://www.sqlservervideos.com/video/copying-and-moving-sql-server-logins/
SQL Server Clustering
Stretch Clusters
http://blogs.technet.com/rob/archive/2009/03/15/sql-server-2005-multi-site-clustering-with-windows-server-2008.aspx
Multi-Site Clusters
http://www.microsoft.com/windowsserver2008/en/us/failover-clustering-multisite.aspx
Failover Cluster Documentation
http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx
SQL Server 2008 Failover Clustering Whitepaper
http://sqlcat.com/whitepapers/archive/2009/07/08/sql-server-2008-failover-clustering.aspx
Denny Cherry's SQL Server 2008 Clustering Articles in SQL Magazine
http://www.sqlmag.com/Article/ArticleID/102461/sql_server_102461.html
http://sqlmag.com/articles/index.cfm?articleid=100400
http://sqlmag.com/articles/index.cfm?articleid=100398
SQL Server Log Shipping
Log Shipping Overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx
Step By Step to Configuring Log Shipping
http://msdn.microsoft.com/en-us/library/ms190640.aspx
Log Shipping Fail Over
http://msdn.microsoft.com/en-us/library/ms191233.aspx
Log Shipping and Additional Dependencies
http://msdn.microsoft.com/en-us/library/ms187580.aspx
SQL Server Database Mirroring
Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx
Providing High Availability with Database Mirroring
http://sqlcat.com/whitepapers/archive/2008/09/02/sql-server-replication-providing-high-availability-using-database-mirroring.aspx
Implementing Failover with Database Mirroring
http://sqlcat.com/whitepapers/archive/2007/12/16/implementing-application-failover-with-database-mirroring.aspx
Performance Best Practices for Database Mirroring
http://sqlcat.com/whitepapers/archive/2007/11/19/database-mirroring-best-practices-and-performance-considerations.aspx
Using Database Mirroring AND Log Shipping Together
http://sqlcat.com/whitepapers/archive/2008/01/21/database-mirroring-and-log-shipping-working-together.aspx
Combining Log Shipping and Replication
http://msdn.microsoft.com/en-us/library/ms151224.aspx
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.
http://msdn.microsoft.com/en-us/library/ms189572.aspx
SQL Server Replication
Books Online Overview
http://msdn.microsoft.com/en-us/library/ms151198.aspx
Management of Replication Agents
This is where the BULK of your more ADVANCED performance and configuration options will be.
http://msdn.microsoft.com/en-us/library/ms152762.aspx
Great Resource for Replication Troubleshooting
http://www.replicationanswers.com
Comments
Loading Comments...