To force a full backup perform the following procedure.
Prerequisites
You must use an account that is a member of the SQL Server sysadmin role to perform this procedure.
Procedure
1. Launch SQL Server Management Studio
2. Connect to the server housing the BizTalkMgmtDb
3a. Run the stored procedure BizTalkMgmtDb.dbo.sp_ForceFullbackup
4a. Execute the job Backup BizTalk Server
Alternatively you can update the adm_BackupSettings table manually to force a full backup without executing step 3 above.
3b. Update adm_BackupSettings Set ForceFull = 1
4b. Execute the job Backup BizTalk Server
Showing posts with label BizTalk. Show all posts
Showing posts with label BizTalk. Show all posts
Tuesday, January 14, 2014
Monday, December 30, 2013
Using BizTalk Terminator
BTSTerminator is a handy tool for managing your BizTalk database environment. Unfortunately it's design is a little confusing.
1. Enter the database server name
2. Enter the name of the management database
BTSTerminator requires that you verify that all the BT databases are backed up, that all host instances on the application server have been stopped, and that all BT SQL Agent jobs are stopped before you can proceed. The thing to note here is that BTSTerminator does not verify these things for you so you need to verify that these are done and then check the check boxes before proceeding. Once everything is checked you can click the Connect button.
The next screen is where things get confusing.
The bottom row of buttons are not actions, they are categories. So if you want to delete orphaned instances you first click the Delete button which changes the options in the top drop down menu.
Basically, all BTSTerminator is, is a collection of various SQL Scripts that are accessed and executed through the (clunky) UI.
1. Select the category of action you want to do (View, Delete, Manage, etc)
2. Select the appropriate task from the drop down menu
3. Click the Parameters tab and verify the parameters (usually just a confirmation of the server and database names)
4. Click Execute
BTSTerminator will then execute the chosen script on the server/database and display the results on the Results tab.
1. Enter the database server name
2. Enter the name of the management database
BTSTerminator requires that you verify that all the BT databases are backed up, that all host instances on the application server have been stopped, and that all BT SQL Agent jobs are stopped before you can proceed. The thing to note here is that BTSTerminator does not verify these things for you so you need to verify that these are done and then check the check boxes before proceeding. Once everything is checked you can click the Connect button.
The next screen is where things get confusing.
The bottom row of buttons are not actions, they are categories. So if you want to delete orphaned instances you first click the Delete button which changes the options in the top drop down menu.
Basically, all BTSTerminator is, is a collection of various SQL Scripts that are accessed and executed through the (clunky) UI.
1. Select the category of action you want to do (View, Delete, Manage, etc)
2. Select the appropriate task from the drop down menu
3. Click the Parameters tab and verify the parameters (usually just a confirmation of the server and database names)
4. Click Execute
BTSTerminator will then execute the chosen script on the server/database and display the results on the Results tab.
Monitor BizTalk Server (BizTalkMgmtDb) job failing
In BizTalk Server 2010 there's a job called Monitor BizTalk Server (BizTalkMgmtDb). This job checks the management and tracking databases and looks for any inconsistencies. If there are none then the job completes successfully. If there are inconsistencies, then the job fails.
The job failing is simply telling you that you must take care of the inconsistencies.
Error message:
Executed as user: [ my user]. 2 Orphaned DTA Service Instances in USWBIZDBSTG01.BizTalkDTADb, 1 Messages with refcount less than 0 in USWBIZDBSTG01.BizTalkMsgBoxDb [SQSTATE 42000] (Error 50000). The step failed.
The numbers may change based on how many inconsistencies the job finds. So don't be surprised if you have more than what I've specified here.
To fix the issue simply run BizTalk Terminator. A search on Microsoft.com will point you to the free download.
The job failing is simply telling you that you must take care of the inconsistencies.
Error message:
Executed as user: [ my user]. 2 Orphaned DTA Service Instances in USWBIZDBSTG01.BizTalkDTADb, 1 Messages with refcount less than 0 in USWBIZDBSTG01.BizTalkMsgBoxDb [SQSTATE 42000] (Error 50000). The step failed.
The numbers may change based on how many inconsistencies the job finds. So don't be surprised if you have more than what I've specified here.
To fix the issue simply run BizTalk Terminator. A search on Microsoft.com will point you to the free download.
- To fix "messages with refcount less than 0" error run Repair Refcounts for All Messages in BTS Terminator.
- To fix "orphaned DTA service instances" error run DELETE Orphaned DTA Service Instance Expections in BTS Terminator.
Subscribe to:
Posts (Atom)