Post reply

Deleting aSpecific Backup Job.

  • November 19, 2003 at 10:50 am

    #106825

    I am using SQL Server 2000 SP3 (v 8.00.760) on a Windows 2000 Server. I have a backup plan set in my SQL database to APPEND to a Disk Backup File as a Complete Backup Method.

    Essentially, this procedure adds each days backup to this file; providing with a unique backup number and also with a Timestamp.

    Is there a way in T-SQL or through Management GUIs I can delete jobs that are prior to 1 month or prior to a certain backup identifier?

    Thanks.

    Naveed

  • November 19, 2003 at 10:57 am

    #482716

    add the [RETAINDAYS = 31] into the backup statement.

  • November 19, 2003 at 11:12 am

    #482720

    Thanks... this helps me when I create a new backup Job. Is there a way I can add this criteria in my existing backup file so that it starts retaining previous 15 days of backup?

  • November 19, 2003 at 11:37 am

    #482721

    quote:

    Is there a way I can add this criteria in my existing backup file so that it starts retaining previous 15 days of backup?

    if you have a scheduled sql job for the backup, you can open it and edit it no problem.

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

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