Post reply

Configure TempDB from command Line

  • November 24, 2014 at 6:39 pm

    #313397

    Hi

    On my test SQL server I was trying to change some options in regard to TEMPDB, but whatever I have done has now prevented me from getting the SQL services to start post configuration.

    Is there a way to configure the TEMPDB options from the command Line?

    Regards

    Brad

  • November 25, 2014 at 4:25 am

    #1760742

    Have a read through this, the section on TempDB should help

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

    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 25, 2014 at 2:51 pm

    #1760927

    Thanks GilaMonster, thats exactly what I needed. I knew there was the ability to do something like that but could not remember exactly what.

    Again thanks

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

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