log shipping of biztalk database on SQL server 2008 standard edition

Posted by Manjot on Server Fault See other posts from Server Fault or by Manjot
Published on 2010-04-25T23:26:34Z Indexed on 2010/04/25 23:34 UTC
Read the original article Hit count: 535

Filed under:

sql-server-2008

|

BizTalk

|

log-shipping

Hi,

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

© Server Fault or respective owner

Related posts about sql-server-2008

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative… >>> More
SQL Server 2008 Vs Sql Server 2008 R2 in web-development

as seen on Stack Overflow - Search for 'Stack Overflow'
This will give many opportunities in Web-development transition from Sql Server 2008 to Sql Server 2008 R2: 1.If database in one instance of SQL Server. 2.a) if in the server PC have 1 processor b) if in the server PC have 4 processors >>> More
SQL Server 2008 to SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an MDF and LDF file of SQL Server 2005. i attached it with SQL Server 2008 and did some change in data. now when i attached it back to sql server 2005 Express Edition it gives version error. The database 'E:\DB\JOBPERS.MDF' cannot be opened because it is version 655. This server supports version… >>> More
SharePoint 2010 – SQL Server has an unsupported version 10.0.2531.0

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I am trying to perform a database attach upgrade to SharePoint Foundation 2010. At this point I am trying to attach the content database to a Web application by using Windows Powershell: Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL>… >>> More
Uninstalling Reporting Server 2008 on Windows Server 2008

as seen on SQL Blog - Search for 'SQL Blog'
Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar… >>> More

Related posts about BizTalk

Future of BizTalk

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The future of BizTalk- The last TechEd Conference was a very important one from BizTalk perspective. Microsoft will continue innovating BizTalk and releasing BizTalk versions for “for next few years to come”. So, all the investments that clients have made so far will continue giving returns. Three… >>> More
BizTalk Server Monitoring – SharePoint Web Part

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I have been worked with customers using BizTalk as shared infrastructure in the enterprise, where we have two or more BizTalk apps running on it for different Business groups. Also these customers are not using BizTalk ESB portal even though they are using BizTalk ESB exception framework. So main… >>> More
Useful Tips for BizTalk 2006 to BizTalk 2009 Porting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
BizTalk projects require some manual intervention in order to upgrade them. Execute the following steps to port a BizTalk solution / project: Open the project’s solution file (.sln) using a text editor – NotePad++ is recommended. Remove all the contents (in red below) between (not including)… >>> More
TFS - How much nesting on disk structure

as seen on Stack Overflow - Search for 'Stack Overflow'
We just got TFS installed and ready go. I'm trying to decide on the disk structure. Let's suppose I have two BizTalk projects called Common and BookTransfer (in actuality I have 7). [At this client, we adopted the style of having schemas, orchs, maps in one project called BizTalk.Artifacts]. A folder… >>> More
BizTalk Server 2009 - Architecture Options

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I recently needed to put forward a proposal for a BizTalk 2009 implementation and as a part of this needed to describe some of the basic architecture options available for consideration. While I already had an idea of the type of environment that I would be looking to recommend, I felt that presenting… >>> More