Red Gate forums :: View topic - LogShipping BizTalk databases
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

LogShipping BizTalk databases

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jeffgonnering



Joined: 03 Jan 2011
Posts: 19
Location: Neenah, WI, USA

PostPosted: Mon Mar 25, 2013 7:18 pm    Post subject: LogShipping BizTalk databases Reply with quote

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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Tue Mar 26, 2013 9:21 pm    Post subject: Reply with quote

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/2301/step-by-step-sql-server-log-shipping/
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group