Post reply

What is the good place to keep the output file of sql agent jobs?

  • June 10, 2009 at 5:18 pm

    #131102

    Hi,

    We have sql server 2005 and has drives C: OS, D: data files, E: Log files, K: Backup.

    We have 16 jobs in sql agent and for all of the jobs, the out put file is writing to D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\FullBackup.txt(here all the jobs writing their output file on DATA drive)

    and select the option Append the out put the existing file.

    So my question is:

    Can we write these log files to drive? will it impact any performance?

    Is better to select the K drive instead of D drive?

    please suggest...

  • June 10, 2009 at 8:04 pm

    #1007748

    I guess, it doesnt really matter to which drive it writes to...Its a very small log file which gets populated as and when job executes and shouldnt be causing any space issues too.

    So, I believe you can point the log whatever drive you wish to depending on your demand / logic.

    Thanks

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

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