Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I want to do log shipping for biztalk databases on SQL server 2008 standard edition (server A) to another SQL server 2008 standard edition (server B).

I was told that for biztalk, logshipping is not like standard logshipping. I was able to find 2 links: http://msdn.microsoft.com/en-us/library/cc296836%28v=BTS.10%29.aspx

http://msdn.microsoft.com/en-us/library/cc296741%28v=BTS.10%29.aspx

but they are not talking about SQL 2008 servers.

Can anyone please help in this?

Thanks in advance

share|improve this question
    
What version of biztalk? –  Jim B Apr 26 '10 at 10:53
    
It is Biztalk server 2009 –  Manjot Apr 27 '10 at 0:02

1 Answer 1

up vote 1 down vote accepted

Biztalk does not support any form of sql server log shipping. Biztalk uses marked transaction log backups to restore on a scheduled basis. For 2009 see What Is BizTalk Server Log Shipping?

share|improve this answer
    
Found scripts from application server. thanks –  Manjot May 11 '10 at 3:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.