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

  • May 9, 2012 at 9:43 pm

    #1485437

    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 ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)