Highlighted
2 Bronze

SQL Server Backups - How to purge backup history?

Is there a way within Networker 8.1 to have the backup history purged during a scheduled SQL Server backup?  Backing up SQL Server 2008R2 with NMM 3.0 using VDI

Thanks

Mike

0 Kudos
7 Replies
Highlighted
7 Thorium

Re: SQL Server Backups - How to purge backup history?

What exactly do you mean by history purged?

0 Kudos
Highlighted
4 Beryllium

Re: SQL Server Backups - How to purge backup history?

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

HTH,
For NetWorker related content - https://www.youtube.com/channel/UC4JLsVyXMyjbQ4i1NaJj5IQ

0 Kudos
Highlighted
2 Bronze

Re: SQL Server Backups - How to purge backup history?

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

0 Kudos
Highlighted
7 Thorium

Re: SQL Server Backups - How to purge backup history?

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

0 Kudos
Highlighted
2 Bronze

Re: SQL Server Backups - How to purge backup history?

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

0 Kudos
Highlighted
7 Thorium

Re: SQL Server Backups - How to purge backup history?

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.

0 Kudos
Highlighted
2 Bronze

Re: SQL Server Backups - How to purge backup history?

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

0 Kudos