April 25, 2016 at 12:47 pm
There are backup jobs which are created by BizTalk.
I have to copy and restore my test DB from server A to Server B.
What is the restore process?
How different is the process from restoring SQL databases?
April 25, 2016 at 2:57 pm
My understanding (from an admittedly limited exposure to Biztalk) is that normal SQL Server backups are used.
The only thing Biztalk does extra is use some markers or other logic to help it restore multiple databases to a consistent state. This is apparently needed because BizTalk distributes its data across multiple databases and SQL Server backups are only designed to maintain integrity and consistency within the single database.
For restoring a single test database you can probably just use the standard SQL restore logic, but beware that you might get inconsistencies between the various BT databases. If you need to restore a consistent set, use the restore tools provided with Biztalk (which I do not know, but I assume they exist - else the special backups make no sense)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply