Post reply

The TEMPDB

  • August 25, 2013 at 6:57 pm

    #279087

    Dear All,

    I have run into a situation wherein some maintenance is required on the Cluster disk that hosts this TEMPDB. So iam having to temporarily move the files residing in there to elsewhere during this downtime. Once the physical disk maintenance is complete I would put back the files to where they were.

    What are the things to be considered and how can I go about it completing it smoothly 🙂 ?

    One other question is doing such a maintenance on the sqls tempdb, will it affect the other system or other databases?

    Many thanks,

    Jai

  • August 26, 2013 at 1:45 am

    #1644808

    Use alter DB and move the files, restart the services to take the settings effective as SQl resets tempdb during startup.

    Regards
    Durai Nagarajan

  • August 26, 2013 at 7:29 pm

    #1644985

    Thanks Durai! My thoughts were like this:

    - shutdown the db

    - move the files from this disk/drive(X) to another temporary disk/drive(Z)

    - perform whatever maintenance to this disk drive X such as format, replace, etc...

    - once maintenance is done, ensure the disk drive X is available;

    - copy the temp files back from Z to the disk drive X

    - startup the db

    Will this work!?

    Thanks..

  • August 26, 2013 at 9:02 pm

    #1644989

    You can omit this step " copy the temp files back from Z to the disk drive X"

    When the SQL services is restarted, the tempdb files are recreated - there is no need to copy them/back them up to a "safe" place...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • August 26, 2013 at 10:54 pm

    #1645001

    Thank you!

  • August 27, 2013 at 1:03 am

    #1645025

    mJai (8/26/2013)

    Thanks Durai! My thoughts were like this:

    - shutdown the db

    - move the files from this disk/drive(X) to another temporary disk/drive(Z)

    - perform whatever maintenance to this disk drive X such as format, replace, etc...

    - once maintenance is done, ensure the disk drive X is available;

    - copy the temp files back from Z to the disk drive X

    - startup the db

    Will this work!?

    Thanks..

    like MyDoggieJessie said you can ignore the tempdb back to drive X

    but why not using alter and restart sql it will have tempdb on different location and DB will be up and running in the interim.

    Regards
    Durai Nagarajan

  • August 27, 2013 at 4:11 am

    #1645097

    Good idea, I think i can try that too, Durai. Thanks!

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

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