SQL Server Backups - How to purge backup history?

We need more details to suggest a solution to your issue. Please elaborate your requirement,

There are system tables that track backup sets.  Over time, they bloat unless action is taken to purge them.  On a standard MS SQL database, this is usually done with SQL Server Management Studio using a maintenance plan (task would be "backup history purge")

Hope this makes sense, I am paraphrasing the DBA here...

Mike

Ah.. you are probably referring to sp_delete_backuphistory (Transact-SQL).  If you have it configured, it will be under Management->Maintenance Plan.

Exactly - so is there a way to trigger that action from the Networker backup config?  We want to avoid setting up maintenance plans on the SQL Servers and run all aspects of the backup from Networker,

Thanks

MP is SQL thing.  In NW there is pre/post for SQL, but you can run this once per year and remove everything older than your retention policy for example.

Hi,

We've decided not to pursue trying to implement a post-backup script in the Networker configuration.  Turns out that the command to run pre- and post- scripts is designed for file backups not database backups.

We will implement a monthly history purge in the SQL Server maintenance plan.

Thanks