Tuesday, January 14, 2014

Force a Full Backup in BizTalk Server

To force a full backup perform the following procedure.

Prerequisites
You must use an account that is a member of the SQL Server sysadmin role to perform this procedure.

Procedure
1. Launch SQL Server Management Studio
2. Connect to the server housing the BizTalkMgmtDb
3a. Run the stored procedure BizTalkMgmtDb.dbo.sp_ForceFullbackup
4a. Execute the job Backup BizTalk Server

Alternatively you can update the adm_BackupSettings table manually to force a full backup without executing step 3 above.

3b. Update adm_BackupSettings Set ForceFull = 1
4b. Execute the job Backup BizTalk Server