Post reply

Tempdb lost - but starting SQL Server with -m -f still fails

  • November 11, 2014 at 3:09 pm

    #312401

    SQL 2008 R2 - drive hosting tempdb was lost. Tried sqlservr.exe -m -f (and sqlservr.exe -c -f -m) but the startup failed.

    Am I missing something or just behind the curve?

  • November 11, 2014 at 3:13 pm

    #1757805

    Try working through this: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    Alternatively, if you want advice, please post exact error messages and detailed description of exactly what happened.

    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

  • November 12, 2014 at 3:33 am

    #1757880

    John Langston (11/11/2014)

    SQL 2008 R2 - drive hosting tempdb was lost.

    Do you plan to replace the drive?

    If so, recreate the folder structure and apply the correct permissions for the service account and tempdb will be recreated.

    John Langston (11/11/2014)

    Tried sqlservr.exe -m -f (and sqlservr.exe -c -f -m) but the startup failed.

    Am I missing something or just behind the curve?

    Invoke the exe using the trace flag 3608, this will only start the master database, you may then issue alter database statements for the tempdb files if you do not plan to replace the lost drive

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply