Solved

SQL Server Clustering Failover Testing

Posted on 2012-04-11
4
206 Views
Last Modified: 2012-06-22
Hi,
I have a 2 node (A/B) SQL server cluster on SQL 2008 R2 & windows 2008.

Node A have default instance configured while Node B got Instance "Test". I need to carry a failover test from A to B (Default + Test instance) and then B to A  (Default + Test instance) .

I need to make sure all underlying config is setup properly before carrying these failover tests so  I am looking for info on 2 things :

1. How to check cluster for failover &
2. How to carry failover

A word doc or blog link preferred than MSDN pages.

Thanks
0
Comment
Question by:crazywolf2010
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:65td
ID: 37832949
0
 

Author Comment

by:crazywolf2010
ID: 37896997
Hi,
Can you pleas list steps for it?

Thanks
0
 
LVL 22

Accepted Solution

by:
65td earned 500 total points
ID: 37898819
0
 

Author Comment

by:crazywolf2010
ID: 37958786
Does someone have more detailed document else blog link for a SQL server cluster fail-over test?
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now