DTA Purge & Archive Job Problem

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › DTA Purge & Archive Job Problem

Viewing 0 reply threads
  • Author
    Posts
    • #18116
      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
      
Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.