"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

May 21, 2011

SQL Server - Learning Resources - Mirroring / Log Shipping

Compiled list of Learning Resources for High Availability - SQL Server Topics

What to know before you choose a SQL Server Disaster Recovery and/or High Availability solution - Cindy Gross Blog

Database Mirroring

Database Mirroring step by step
SQL Server 2005 Database Mirroring
Database mirroring and log shipping. Which is better?
Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Database Mirroring with Log Shipping
Require Checklist Details : Mirroring Setup
Database Mirroring With Replication
Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup

Log Shipping

Log Shipping Step-by-Step
How to configure and monitor log shipping in sql server


Clustering

SQLBits Session - SQL Server Clustering for Dummies
SQL Server 2008 Clustering step by step
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 1)
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 2)
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 4)
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 5)
SQL Server 2005 Clustering Tips/References - Cindy Gross blog
Prepared below table after reading blogs / articles
SQL Server Configuration checklist and related presentation.
Scalable shared databases are supported by SQL Server 2005
Disasters and Recovery

From my experience 
  • Mirroring Server was used as backup for Transaction Production Server
  • Replicated database was used for downstream systems to lookup for information
  • While installing Biztalk, Biztalk database were configured for failover clustering

More Reads
How to configure SQL Server Database Mail to send email using your Windows Live Mail Account or your GMail Account
Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server
Tips & Tricks: SQL Server Mail Configuration

Happy Learning!!

No comments: