Change of Temp DB Location in SQL 2008R2 Cluster

  • 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

  • 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" 😉

  • 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

  • the move is as for a standalone server.

    No need to reboot anything, just offline\online the SQL resource via failover cluster manager

    ---------------------------------------------------------------------

  • 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