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