May 28, 2015 at 8:29 am
Hello Team,
I'm planning to change the location of Temp db in Cluster, Just need to know if there are any differences while changing the location in cluster
Thanks
Dave
May 28, 2015 at 9:55 am
just use the following for any tempdb files and restart the instance
alter database tempdb modify file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2015 at 10:19 am
So this is straight forward work like moving the the Temp DB on Standalone server
There is anything else I need to consider before making the move
I have a A/P cluster
do I need to reboot both nodes after the change? or just to make sure failover is working properly I need to reboot both machines
Thanks
May 29, 2015 at 6:26 am
the move is as for a standalone server.
No need to reboot anything, just offline\online the SQL resource via failover cluster manager
---------------------------------------------------------------------
May 29, 2015 at 10:21 am
Thanks SSCertifiable
Regards.
Dave
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply