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:
Post a Comment