LogShipping BizTalk databases

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

LogShipping BizTalk databases

Postby jeffgonnering » Mon Mar 25, 2013 7:18 pm

Looking for advice on how to log ship BizTalk databases. They have a special, built-in backup job that does (native) full and log backups, so I do not want to use SQL Backup as Microsoft says it does not support 3rd party backups of BizTalk databases. Is there any way I could use the native log backups that it generates with SQL Backup log shipping job running on the destination server? In other words, can the Restore command handle a native backup? Is there a converter program from native to .sqb? (I know there is one from sqb to native). Thanks.
jeffgonnering
 
Posts: 19
Joined: Mon Jan 03, 2011 11:35 pm
Location: Neenah, WI, USA

Postby Manfred.Castro » Tue Mar 26, 2013 9:21 pm

Is there any way I could use the native log backups that it generates with SQL Backup log shipping job running on the destination server?
Theoretically you could modify the jobs created by SQL Backup logshipping to use native SQL Server syntax for backup and restore.(I wouldn't recommend this.)

In other words, can the Restore command handle a native backup?
The SQL Backup restore command will not be able to handle the native backup file.

Is there a converter program from native to .sqb?
We do not have a converter for .bak to .sqb.

I would recommend that you use native log shipping in your case.
Here is an article I found that should point you in the right direction to get that set up.

http://www.mssqltips.com/sqlservertip/2 ... -shipping/
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests