Veeam remove old jobs

select * from [backup.model.backups] where job_name = ‘Weekday B2D IPRecorder on Tape’

DECLARE @BackupID uniqueidentifier SET @BackupID = ‘{A2BF2695-1E48-4D96-8065-AB81FA55400F}’

delete [Backup.Model.OIBs] from [Backup.Model.OIBs] join [Backup.Model.Points] on [backup.model.oibs].point_id = [backup.model.points].id where [backup.model.points].backup_id = @BackupID delete [Backup.Model.OIBs] from [Backup.Model.OIBs] join [Backup.Model.Storages] on [backup.model.oibs].storage_id = [Backup.Model.Storages].id where [Backup.Model.Storages].backup_id = @BackupID delete from [backup.model.points] where backup_id = @BackupID delete from [Backup.Model.Storages] where backup_id = @BackupID delete from [Backup.Model.Backups] where id = @BackupID

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s