Update to Stored Procedure to delete Backup BizTalk Server SQL Agent backup files

Since BizTalk 2004 there has been an issue with the Backup BizTalk Server SQL Agent job (this is the only supported way to backup the BizTalk Server Databases), the issue is that the job never deletes the backup files it creates. There is a step in the job that clears the backup history table in […]

Interesting Side-Effect of specifying BackupHour on BackupFull Step of the Backup BizTalk Server SQL Agent Job

With a hotfix that was introduced in BizTalk Server 2006 you can now specify the hour that you want the Backup BizTalk Server SQL Agent job to do the full backup of the BizTalk Server Databases, the default behaviour for this step of the job is to create the full database backups at change of […]