Hi,

I have tried the steps you suggest (and many other options found elsewhere on the web) but have not been able to get any to work. I first followed the guide at the "Moving TempDB - SQL School Video" on this site and then tried your steps.

I either end up with the db in "Recovery Pending" state, or the "Bring Online" fails saying that the "Set Offline failed" even it did not say so when I did it! The mdf/ldf is left unchanged and the only way I have found to recover the situation is to delete the db from within SSMS and the windows folder then copy my backup mdf back in, reattach and then I am back where I started with the un-renamed mdf...

I am a newbie with SQL and am struggling to understand why such a simple sounding task should be so hard (notwithstanding it may be nothing to do with SSMS and I just don't know why)... I have also looked at the file permissions before during after each step and can't see anything changing there (always stay at full permission for all