Home Forums SQL Server 2008 SQL Server 2008 Administration Lost drive where tempdb resides - need to move tempdb while sql services are not running RE: Lost drive where tempdb resides - need to move tempdb while sql services are not running

  • No, you'll need to start SQL in it's minimal config mode, then run the ALTER DATABASE to change the tempDB location

    Start SQL from the command line with the following (I think this is right):

    sqlservr.exe -m -f -T3608

    With that, SQL will be started single user, minimal config. One connection can then be made (and only one), you can run the alter database to move tempDB, then restart SQL normally and it should start fine.

    Edit: added missing traceflag.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass