Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.