5 min read
New release: Managing and cleaning BizTalk Server MarkLog database tables: sp_DeleteBackupHistory...
Sandro Pereira
May 26, 2014
Almost three weeks ago, in my last post I release a SQL script to manage and delete the unnecessary records in the BizTalk “MarkLog” tables according to
8 min read
Managing and cleaning BizTalk Server MarkLog database tables according to some Best Practices
Sandro Pereira
May 6, 2014
All the BizTalk databases are being backed up by the Backup BizTalk Server job This means that all databases, except the BAM Star Schema database
4 min read
A different way to Force a Full Backup of the BizTalk Server databases
Sandro Pereira
Apr 15, 2014
The health of BizTalk Server databases is very important for a successful messaging environment BizTalk ships with 13 SQL Agent jobs that perform important
6 min read
How to create a Maintenance Plan to delete BizTalk Database Backups files
Sandro Pereira
Jun 26, 2013
BizTalk Server database databases and their health are very important for a successful BizTalk Server database messaging environment This is nothing new, and
4 min read
How to configure SQL Server Network Protocols in the SQL Server that houses BizTalk Server databa...
Sandro Pereira
Apr 4, 2013
Today is a special day for me, it’s my birthday, and I will continue the tradition of giving something to the community on this day (I started this
14 min read
BAM Portal Errors – Failed to list permissions for BAM view. System.Data.SqlTypes.SqlNullVa...
Sandro Pereira
Dec 4, 2012
I decided to put the name of the error in the post title but this post also could be called “Why you shouldn’t delete Active Directory accounts (if you
3 min read
“Cannot open database ‘…’ requested by the login. The login failed” or “The EXE...
Sandro Pereira
Feb 29, 2012
It's very common for orchestrations to access databases or execute stored procedures Whether this access is done by SQL Adapter, WCF-SQL adapter, or through C
3 min read
Some considerations that we should have when migrating databases to a new SQL Server
Sandro Pereira
Jan 26, 2012
This post is not really about BizTalk… but since I've been configuring several environments for my client, I decided to take these notes Basically, we have
