Post reply

Hot Issue With TEMPDB Creation

  • September 10, 2010 at 10:40 am

    #238050

    Hi Folks

    Got myself into a jam trying to move TEMPDB

    Did not notice that there was not enough disk space where I moved it and did not check before i

    recycled services

    Consequently SQL server will not start as it is trying to create a file bigger than available space

    Anyone know how to get me out of this jam ?

    Thanks

    Jim

  • September 10, 2010 at 1:12 pm

    #1219433

    Start up SQL using the following flags (/f /T3608) in the command line

    Or start the service like this: NET START MSSQLSERVER /f /T3608

    These flags will prevent SQL from starting up any database besides Master. Once you're running, do the same Alter TempDB and move it somewhere else, then restart without the flags.

  • September 10, 2010 at 1:19 pm

    #1219436

    Excellent Derrick

    I am back in business

    Thanks

    Jim

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

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