Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (fMicrosoft Partne)
  • When: 22 Feb 2012 12:24 PM
  • Last revision by
  • When: 10 Sep 2013 12:28 PM
  • Revisions: 37
  • Comments: 26
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Aspects of Backup for BizTalk Databases

Aspects of Backup for BizTalk Databases

Aspects of Backup for BizTalk Databases

Table of Contents



Introduction

When it comes to making backups of BizTalk, there is only one way that is supported by Microsoft; you need to make Log Shipping Backups. A number of usable articles have been written about making backups of BizTalk databases and other related databases. These articles are summed up and categorized in this article.

Why and how to make Log Shipping Backups

  • For BizTalk Microsoft supports only Log Shipping backups. Why?
  • Make Marked backups instead of regular Full Backups. This article provides many insides of how the Backup BizTalk Server job works
  • The original article on MSDN on making Marked backups
  • Configuring/using Log Shipping Backups can be found here

How to add/remove custom databases to the backup

  • In extension of making backups of your BizTalk databases, this article explains how custom databases should be added to the Backup BizTalk Server job.
    The article also gives some more inside information about the view which shows the databases which are in your BizTalk backup
  • How to remove custom database from BizTalk Log Shipping can be found here

Note: Only the addition of SQL Server databases is supported.

Clean up backup artifacts

  • Automatically remove old backup files with a SQL Server Maintenance Plan is described here
  • Automatically remove old backup files with a SQL Script is described here
  • Delete old backup files and folders with PowerShell is described here
  • Query to retrieve the number of records in the MarkLog tables in the TechNet Galleryis here
  • Cleaning up large MarkLog tables can be found here

See Also

Read related suggested topics:

  • How to backup your system databases (normally not in the Backup BizTalk Server job) is described here
  • Forcing a Full BizTalk backup on BizTalkAdminsBlogging
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.
, , , , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 2 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 17 May 2012 2:21 AM

    Patris_70 edited Revision 9. Comment: added en-US title and tag

Page 3 of 3 (21 items) 123
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 10 Sep 2013 12:28 PM

    Maheshkumar S Tiwari edited Revision 35. Comment: corrected typo error and minor formatting

  • Posted by
    on 13 Aug 2013 3:49 AM

    Great job

  • Posted by
    on 11 Jul 2013 2:07 PM

    Very good article

  • Posted by
    on 24 Jul 2013 1:24 PM

    Good list of resources.

  • Posted by
    on 28 Feb 2012 4:55 PM

    Ed Price - MSFT edited Revision 4. Comment: Title casing

  • Posted by
    on 3 Mar 2012 3:53 AM

    Thanks Ed. Every improvement counts. :-)

  • Posted by
    on 7 Mar 2012 11:54 AM

    Lex Hegt edited Revision 5. Comment: Added the query to retrieve the number of records in the MarkLog tables

  • Posted by
    on 25 Mar 2012 2:18 AM

    Lex Hegt edited Revision 6. Comment: Added a link to the Forcing a Full BizTalk backup post on BizTalkAdminsBlogging

  • Posted by
    on 8 May 2012 4:44 AM

    Lex Hegt edited Revision 7. Comment: Added Saravana's article

  • Posted by
    on 17 May 2012 1:28 AM

    Lex Hegt edited Revision 8. Comment: Added an article on how to remove custom databases from BizTalk Log shipping

  • Posted by
    on 17 May 2012 2:21 AM

    Patris_70 edited Revision 9. Comment: added en-US title and tag

Page 2 of 2 (26 items) 12