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?

1 Answer 1


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

  • Cheers for the confirmation - haven't done this before and wanted to check first
    – mealies
    Apr 10, 2012 at 14:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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