Post reply

Change of Temp DB Location in SQL 2008R2 Cluster

  • May 28, 2015 at 8:29 am

    #297252

    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

    #1801305

    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

    #1801313

    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

    #1801542

    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

    #1801652

    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