Post reply

Help! Sql server won''t start

  • February 28, 2007 at 3:06 pm

    #123129

    I mistakely moved tempdb to a drive that doesn't have enough space, and now SQL Server won't start. 

    Does anyone know a place in the registry where I can change the path for the tempdb file?  Any other options?

    Thanks for  the help! 

    Olga

  • February 28, 2007 at 3:26 pm

    #692451

    start SQL Server in mimimal configuration mode by using the (-f) startup parameter in command window

    and move the tempdb database to a valid location.

    See BOL topic "minimal configuration" how start sql server with -f switch

    sqlservr.exe -f -s <instancename>

    Alter database tempdb modify file

    (name = tempdev, filename = 'C:\MyPath\tempdb.mdf')

    Alter database tempdb modify file

    (name = templog, filename = 'C:\MyPath\templog.ldf')

     

    MohammedU
    Microsoft SQL Server MVP

  • March 1, 2007 at 9:17 am

    #692652

    Thanks for the reply. Mohammed. 

    The command worked but I can't login, the error message says only one administrator can login in a single user mode.  Any suggestions?

    Thanks!

  • March 1, 2007 at 2:20 pm

    #692717

    Stop SQL Server Agent as it may be using the connection.

  • March 1, 2007 at 2:44 pm

    #692721

    The SQL Agent is not running. 

    I think I am getting the error because I don't have a windows authenticated sql account for the user I am looged in with.

    I am having the network group throw in some disk space for me.  Good thing it's just a lab box!

    Thanks for your help. 

Viewing 5 posts - 1 through 4 (of 4 total)

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