Moving tempdb log in an AlwaysOn AG

  • I have a 2 node AlwaysOn AG. I need to understand how to move the tempdb.log file to another drive. Should I run the T-SQL on the failover node first and restart, and then failover to the failover node. Then run the T-SQL on the primary and restart SQL instance, eventually failing back to the primary server? I think this would be the way to do this, just want to make sure I don't destroy our production boxes.

  • That sounds like the way I would do it.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Thanks Kevin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply