June 14, 2017 at 1:17 pm
Hi,
I am going to move one data files for tempdb on a 2 node cluster environment. Can anyone tell me what are the precautions should I take specially for the cluster environment? The client don´t want FailOver to another Node (passive).
Thanks
June 14, 2017 at 2:06 pm
None really.
You have to restart the instance for the ALTER DATABASE to take effect and actually move the files, so whether you do that as a failover and failback or whether you prevent the cluster from failing over and just restart SQL on the active node is your choice.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2017 at 2:21 pm
Thanks! I will do this. For prevent the FailOver (The company dont´t want it) , I will "pause" the passive node.
June 15, 2017 at 5:02 am
carolmartinesgarcia - Wednesday, June 14, 2017 2:21 PMThanks! I will do this. For prevent the FailOver (The company dont´t want it) , I will "pause" the passive node.
as long as you have not modified the cluster resource policies extensively there'll be no issue with failover.
Move the temdb files in the system catalogs using the following syntax
ALTER DATABASE ... MODIFY FILE ...
Once this is done, arrange an outage and open Failover Cluster Manager. Right click the sql server resource and take offline. To restart, right click the sql server agent resource and select online
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply