Deleting Backup Log files

Last Post 15 Jan 2008 04:17 AM by lorrie hollinger. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
lorrie hollinger
New Member
New Member

--
15 Jan 2008 04:17 AM
I created backup devices and scripted jobs for full, differential and transactional backups and included retain parameters using SQL Server 2000. When I look at the "Management, Backup, DeviceName,View Backup Media Contents" I can see all of the logs that were created and it shows me the ones that were expired.

What I need to find out is how to delete these expired logs. First, how do I delete the ones that are in existence already, and second, what code do I include in my jobs to delete these logs as soon as they are expired.

Any help would be appreciated.

Thanks.

Lorrie Hollinger
You are not authorized to post a reply.

Acceptable Use Policy