05-09-05 10:49 PM
Yup, in this scenario there is a dtc under the covers that involves the
msgbox and your db.
Thanks,
Joel
--------------------
| From: "McGeeky" <anon@anon.com>
| References: <ujBDe4#TFHA.616@TK2MSFTNGP12.phx.gbl>
<zfvofcMUFHA.3336@TK2MSFTNGXA01.phx.gbl>
| Subject: Re: Synchronizing BizTalk database backup with application
database backup
| Date: Wed, 4 May 2005 20:54:24 +0100
| Lines: 109
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <#30CgMOUFHA.3864@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.biztalk.general
| NNTP-Posting-Host: cpc3-sout3-6-0-cust241.sot3.cable.ntl.com
81.111.126.241
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:13577
| X-Tomcat-NG: microsoft.public.biztalk.general
|
| Hey Joel - that's fantastic! Thanks for all that information! Its just
what
| we wanted to hear!
|
| The application database is being updated exclusively by the SQL Adapter
| from BizTalk so I am presuming DTC will be taken care of... or not?
|
|
| --
| McGeeky
| http://mcgeeky.blogspot.com
|
|
| "Joel West" <jdwest@mail.microsoft.com> wrote in message
| news:zfvofcMUFHA.3336@TK2MSFTNGXA01.phx.gbl...
| > Yes, this is possible (and supported). When you say that you need your
| > database to be "in sync" with BTS I assume that this is because you are
| > participating in a DTC that spans a BTS db and your db (see SQL books
| > online for background on log marks). If this is not the case you can
| still
| > incorporate your db into the BTS backup process but there won't be any
| > synchronization.
| >
| > Here are the steps to add a 3rd party database to our backup process:
| >
| > Build the objects in the new database:
| > 1. Locate the <install dir>\Microsoft BizTalk Server 2004\Schema dir
and
| > run Backup_Setup_All_Procs.sql and Backup_Setup_All_Tables.sql in the
| > target database. This creates the necessary procs, table and role and
| > assignees permissions to the stored procs.
| > Configure:
| > 2. Link the Sql Server holding the Mgmt database to the Sql Server
| holding
| > the new database. The account used to run the Sql Agent service on the
| > Mgmt Sql Server must be either a domain account or a local account that
is
| > mapped to each machine holding a database to be backed up. If the
| > databases are on the same machine skip this step.
| > 3. Add a login on the Sql Server that holds the new database for the
| > account running the Sql Agent service on the Mgmt Sql Server. If the
| > databases are on the same machine skip this step.
| > 4. Add a user in the new database for the login created in the previous
| > step and add them to the BTS_BACKUP_USERS role. This role is created
and
| > granted execute on the necessary procs by the scripts in step 1.
| > 5. Add the database to the BizTalkMgmtDb..adm_OtherBackupDatabases
table:
| > DefaultDatabaseName - the name of your database
| > DatabaseName - the name of your database (yes,
| > DefaultDatabaseName and DatabaseName hold the same values for this
| > scenario).
| > ServerName - the name of the sql server that holds your
| > database
| > BTSServerName - the name of the server that holds the
| > Management database.
| >
| > As for testing to know whether or not your database is in sync - go
| through
| > the restore process outlined at
| >
|
http://www.msdn.microsoft.com/libra...y/en-us/operati
| > ons/htm/ebiz_ops_backuprestore_fexk.asp for all databases. This is an
| > important process to rehearse to make sure that your backup
| > process/disaster recovery plans work as expected. If you can correctly
| > restore your database to the same mark name as the other BTS databases
all
| > of your state that is based on distributed transactions shared with BTS
| > should be in sync with the state in the BTS dbs.
| >
| > One other thing - you mention "backup stored procedures". Just an FYI -
| > the only support method of kicking off the BTS backups is through the
| > Backup BizTalk Server Sql Agent job.
| >
| > Thanks,
| > Joel
| >
| > --------------------
| > | From: "McGeeky" <anon@anon.com>
| > | Subject: Synchronizing BizTalk database backup with application
database
| > backup
| > | Date: Tue, 3 May 2005 15:37:07 +0100
| > | Lines: 14
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| > | Message-ID: <ujBDe4#TFHA.616@TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.biztalk.general
| > | NNTP-Posting-Host: 194.129.182.225
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:13511
| > | X-Tomcat-NG: microsoft.public.biztalk.general
| > |
| > | I am planning the database backup strategy for our system. I know that
| > | BizTalk has database backup stored procedures that we can take
advantage
| > of
| > | that ensure that all the BizTalk databases are backed up as a set.
| > |
| > | We also have an application specific database that also needs backing
| up.
| > | But this must also be kept in sync with the BizTalk databases during a
| > | backup. How can I make sure that happens? Has anyone done that before?
| > |
| > | --
| > | McGeeky
| > | http://mcgeeky.blogspot.com
| > |
| > |
| > |
| > |
| >
|
|
|
[ Post a follow-up to this message ]
| 
