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
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...
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,
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.
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.