Dear All,
Our BizTalkDTADb.mdf file was of size 631 MB, and BizTalkDTADb_log.LDF was
of less than 100 MB. But when we configured and Enabled the Purge and Archive
Job, to run after every minute, it ran successfully, took the db archive on
the desired location, but there was no change in the DTADB mdf file size, it
was still 631 MB, same after shrinking the db, no change. The more alarming
thing is that after enabling this job the log.LDF file has kept on growing
and it was at 815 MB, when I finally disabled the job again. I am pasting the
Procedure command that we used to configure the job. Kindly tell us what
might be going wrong and what we should do to correct it:
exec dtasp_BackupAndPurgeTrackingDatabase
0, --@nLiveHours tinyint, --Any completed instance older than the live hours +live days
1, --@nLiveDays tinyint = 0, --will be deleted along with all associated data
30, --@nHardDeleteDays tinyint = 0, --all data older than this will be deleted.
'\\BackUpServerIP\Backup', --@nvcFolder nvarchar(1024) = null, --folder for backup files
null, --@nvcValidatingServer sysname = null,
0 --@fForceBackup int = 0 –
Regards
Sajid