Moving SQL Server 2000 TempDB .mdf File

[bbturner]

I am trying to mover SQL Server 2000's TEMPDB .mdf file from the installed location (C:\MSSQL\DATA...) to another drive (E:\MSSQL\DATA...)

Upon completion, the SQL Server Agent Service will not start - stating "Trying to Recover SQL Server Database'

The rights are ok (local admin) and I followed the instructions for 7.0 found on MS's site:

http://support.microsoft.com/support/kb/articles/Q224/0/71.ASP

The e: drive is a seperate physical Raid 5 array..

 

[bbturner]

Replying to myself on this one... Microsoft announced a bug (and a fix) to this one... on Fri 2/16/2001... In fact, there is a problem trying to relocate SQL Server 2000's TEMPDB .mdf file onto another drive other than where it was installed...