Solved

SQL Server Clustering Failover Testing

Posted on 2012-04-11
4
214 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

687 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