Home Forums SQL Server 2005 Administering why i can't shrink tempdb data file RE: why i can't shrink tempdb data file

  • May 10, 2012 at 11:47 am

    #1485868

    Bhuvnesh (5/9/2012)

    mike schreiner (5/9/2012)

    2. Go to cmd prompt and Run as Administrator

    5.Go to the Binn directory of the SQL Server instance. In this case it was d:\Program Files\Microsoft SQL Server\MSSQL10_50.AFVCSQLSERVER01\MSSQL\Binn

    6.In the cmd prompt, type the following-

    sqlservr -c -f -sAFVCSQLSERVER01

    IF YOU DON'T have a SQL Server instance, just type sqlserver -c -f

    KEEP THE CMD WINDOW OPEN!!!!!

    Why we require this ?

    I'm thinking it's because you're in single user mode and if you close the command prompt, you lose the query window you just opened. But I will admit that I'm just guessing.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.