Post reply

How to make tempdb as secondary file

  • June 4, 2014 at 12:39 am

    #292019

    Can I make secondary file of tempdb in sql server 2008

  • June 4, 2014 at 1:00 am

    #1718743

    Yes, you can add secondary file(.ndf) to tempdb.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • June 4, 2014 at 1:07 am

    #1718744

    How can i add secondary file in tempdb???

  • June 4, 2014 at 1:16 am

    #1718745

    By executing following command:

    ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdb1', SIZE = 5120000KB, FILEGROWTH = 1024000KB, FILENAME = '<path>\tempdb1.ndf' )

    GO

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • June 4, 2014 at 1:24 am

    #1718747

    thanx..

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

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