Post reply

TempDB not using secondary data file

  • January 17, 2011 at 6:42 pm

    #243812

    Hi

    I have created a new secondary datafile for the temp DB but the file is still growing to the point that the file fills the disk. Is there some way that I can get SQL to use the secondary file before it dies?

  • January 17, 2011 at 8:48 pm

    #1274452

    You can set a max size to the primary data file in a such a way that it will leave some free space on the drive. This will ensure that the drive will not be filled up and continue to grow on the secondary file without raising any alerts/warnings.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • January 18, 2011 at 5:16 pm

    #1275055

    Thanks, I was under the missguided impresion that SQL would track the space on the disk as well, silly me;-)

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

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