Post reply

Moving TempDB - SQL School Video

  • November 25, 2008 at 7:17 pm

    #63691

    Comments posted to this topic are about the item Moving TempDB - SQL School Video

    Brian Knight
    Free SQL Server Training Webinars

  • December 30, 2008 at 12:04 am

    #918785

    Good one...:)

  • February 20, 2009 at 9:10 am

    #947598

    Thanks, Brian. Very easy to understand and follow based on your presentation.

  • November 18, 2009 at 5:35 am

    #1080809

    Hi,

    It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.

    Plz update on this ....

    Waiting for your reply.

    Thanks and Regards

    Eswari.S

  • June 21, 2012 at 1:26 am

    #1503795

    Hi

    Thanks. Easy and straight to the point.

    How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is active?

    Thanks

    Shane

  • February 2, 2013 at 7:54 pm

    #1583682

    Nice..............

  • February 3, 2013 at 8:57 am

    #1583720

    touchwithme2 (11/18/2009)

    Hi,

    It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.

    Plz update on this ....

    Waiting for your reply.

    Thanks and Regards

    Eswari.S

    No, you cannot move the tempdb (or any database files) without an outage. For normal databases, moving the files just requires that database to be offline. For system databases, moving the files requires a restart (at a minimum) of SQL Server.

    For tempdb, you can make the changes to the system tables at any time - then at the next restart of SQL Server the files will be created in the new location. Be aware that if you make a mistake on the path for tempdb (e.g. typo in the directory name) - SQL Server will not start and you will have to start SQL Server in single-user mode to fix.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • February 3, 2013 at 9:15 am

    #1583721

    Shane Clarke (6/21/2012)

    How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is active?

    Same way. No, just once. The settings are stored in master and master will be on shared storage.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 8 posts - 1 through 7 (of 7 total)

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