Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to do a restart of the clustered SQL instance to fix a problem with tempDB and i am not sure of the easiest way to do this. We have just upgraded our servers to Windows 2008R2 running SQL 2008R2. The main cluster is a 2 node cluster running active/passive.

As this is just to fix tempDB, my current plan is to just move the clustered SQL instance to the passive node and fail it back again, is this the best way?

share|improve this question
up vote 1 down vote accepted

As you've already noted failing over to the secondary then failing back to the primary when you're done is the easiest way. Whenever we have to perform work on a clustered instance over here the above mentioned is the way we do it. It's the quickest way

share|improve this answer
Cheers for the confirmation - haven't done this before and wanted to check first – mealies Apr 10 '12 at 14:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.