November 13, 2015 at 11:05 pm
I have never managed Biztalk databases and heard from a Biztalk guy that the way these are handled is lot different from normal SQL DB backup and restore. Gone through some msdn sites and but still not clear .
1.For Biztalk there is seperate job for DB backup including log backup.
Is it must to have log backup as we dont need a point in time recovery.
2.Those sites were mentioning about destination.
what if i need to restore on same server?
3.Restore mention about log shipping.
Is it must to have log shipping for Biztalk, how about a normal restore?
Hope here we have experts worked on Biztalk
November 15, 2015 at 4:48 am
Experts please comment:crying::-D
November 16, 2015 at 1:28 am
Have a look at this link:
November 16, 2015 at 1:42 am
Thanks a lot Justin.
The sp_ForceFullBackup stored procedure in the BizTalkMgmtDb database can be used to help perform an ad-hoc full backup of the data and log files. The stored procedure updates the adm_ForceFullBackup table with a value 1. The next time the Backup BizTalk Server job is ran, a full database backup set is created.
Any idea what happens the job normally run?? it create a full backup right!!!
November 16, 2015 at 2:10 am
David Rich (11/13/2015)
I have never managed Biztalk databases and heard from a Biztalk guy that the way these are handled is lot different from normal SQL DB backup and restore. Gone through some msdn sites and but still not clear .1.For Biztalk there is seperate job for DB backup including log backup.
Is it must to have log backup as we dont need a point in time recovery.
2.Those sites were mentioning about destination.
what if i need to restore on same server?
3.Restore mention about log shipping.
Is it must to have log shipping for Biztalk, how about a normal restore?
Hope here we have experts worked on Biztalk
1. If you don't need point in time recovery, rather place the database into Simple Recovery mode and do Daily full backups?
2. Destination - Are you referring to where you are placing your backups?
3. Log Shipping - Are you making use of log shipping for BizTalk? I don't think its a requirement to have log shipping in a BizTalk Implementation, unless its a business requirement of sorts from your copany?
November 16, 2015 at 2:16 am
November 16, 2015 at 3:33 am
David Rich (11/13/2015)
I have never managed Biztalk databases and heard from a Biztalk guy that the way these are handled is lot different from normal SQL DB backup and restore. Gone through some msdn sites and but still not clear .1.For Biztalk there is seperate job for DB backup including log backup.
Is it must to have log backup as we dont need a point in time recovery.
2.Those sites were mentioning about destination.
what if i need to restore on same server?
3.Restore mention about log shipping.
Is it must to have log shipping for Biztalk, how about a normal restore?
Hope here we have experts worked on Biztalk
BizTalk uses its own default backup jobs, they use a transaction mark in the backupset to synchronise the restores. You could replace these jobs with your own backup jobs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2015 at 10:38 pm
Thanks Guys.
Found below link which is much more simple to understand i feel.:unsure:
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply