• 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