Post reply

Backup results written to text files in SQL 2005

  • November 1, 2010 at 2:35 pm

    #240537

    Thank you to anyone who is able to assist me with this question.

    I am doing full backups daily and hourly transaction log backups on all my databases in a SQL 2005 instance. When each job completes, a small text file in the form of <Job Name_YYYYMMDDmmss>.txt is written showing the duration, status, start time, end time, etc. into the default C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder.

    I do have a Clean Backup History Maintenace Plan that cleans out the Backup History form MSDB older than 3 months. But the text files remain. Does anyone have a good way to clean out these text files also?

    I am running SQL 2005 SP3.

    Thank you.

  • November 1, 2010 at 2:55 pm

    #1245095

    @ john

    create a maintenance plan task with just a maintenance cleanup task.

    In that,

    select delete files of following types:-

    maintenance plan text reports

    File location:-

    search folder and delete files based on an extension

    your path.c:\prog\mssql\.....

    with extension txt

    In the end, you can select delete files older than...as you desire

    Create this maintenance plan and schedule it as you like, once in a week/everyday/monthly.

    Regards,

    Sushant

    Regards
    Sushant Kumar

  • November 1, 2010 at 3:29 pm

    #1245108

    Thank you Sushant - that was too easy. Appreciate it.

  • November 2, 2010 at 6:28 am

    #1245304

    I clean up the text files in the same maint plan that does the backup ...

  • November 2, 2010 at 8:12 am

    #1245399

    Thank you - I have added the cleanup to my existing Backup Maintenance plans and the cleanup is working properly.

    Thanks to everyone who answered.

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

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