Biztalk Db backup job

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk Db backup job

Viewing 1 reply thread
  • Author
    Posts
    • #19493

      Hello,
           In the Biztalk sql node we would like to schdule a backup job that would take a full backup once a day and      transactional log backup every hour.
           we are planning to write a custom SSIS package to do this.We want to backup only the DTA db and Msgbox db.
           We do not use BAM, BRE etc. so only we thought of writing a custom package.
           There is a job that ships by default with Biztalk; but the default jobs backups all the Biztalk dbs. 
           so only we thought of a custom SSIS package.
           Is there any problem with this approach?

      Regards,
      anony
           

    • #19499

      There is no problem in doing that however you risk losing the integrity of your environment if you do (and I believe you won’t be supported by MS in the event that a restore doesn’t go quite to plan). To quote from MSDN (http://msdn.microsoft.com/en-us/library/aa577848.aspx):

      The Backup BizTalk Server Job creates synchronized backups of all
      BizTalk Server databases by using full database backups and transaction
      log backups, in conjunction with a type of transaction known as a marked transaction.
      Marked transactions are transactions that place a mark into the
      transaction log of all databases participating in the transaction. The
      marked transaction blocks new distributed transactions from starting,
      waits for the distributed transactions that are currently running to
      complete, and then executes to place the mark.

      The mark
      represents a transaction point that is consistent across all databases;
      you can use the mark with subsequent log backups to restore your
      databases to that point.

      If you want to take a full backup once a day and then hourly transaction log backups this can be acheived by configuring the BizTalk backup job – see http://msdn.microsoft.com/en-us/library/aa577848.aspx

      In fact, there is a good, in-depth section on BizTalk Backup and Restore which is well worth a read at http://msdn.microsoft.com/en-us/library/aa562140.aspx

      Hope this helps, Nick.

       

       

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.