DTA Purge and Archive Job Failed
Yes! It does not work "by default" when you install fresh BizTalk Server
How to fix it ?!
Open properties of the job and select Steps
Select Archive and Purge the only step and click Edit
change the parameters of the procedure
@nLiveHours tinyint to 1
@nLiveDays tinyint to 0
@nHardDeleteDays tinyint to 0
@nvcFolder nvarchar(1024) to '\\MyServer\backup'
@nvcValidatingServer sysname to null
@fForceBackup int to 0
the edited command should look like
exec dtasp_BackupAndPurgeTrackingDatabase 1, 0, 1, 'c:\backup', null, 0
save it and try to run job one more time
How to fix it ?!
Open properties of the job and select Steps
Select Archive and Purge the only step and click Edit
change the parameters of the procedure
@nLiveHours tinyint to 1
@nLiveDays tinyint to 0
@nHardDeleteDays tinyint to 0
@nvcFolder nvarchar(1024) to '\\MyServer\backup'
@nvcValidatingServer sysname to null
@fForceBackup int to 0
the edited command should look like
exec dtasp_BackupAndPurgeTrackingDatabase 1, 0, 1, 'c:\backup', null, 0
save it and try to run job one more time
Comments