I am a dba at a company and we happened to have a power shortage.Our servers were shut down.
The problem now is that the database biztalkmsgboxdb went into "suspect" mode and I couldnt put it back online without data loss.
I have a backup which is 20 minutes old, so I restored my backup 20 minutes earlier which made me lose all the data that went to this database during these 20 minutes.
My question is what is the effect of this data loss on the biztalk transactions that were done during these 20 minutes? Is this database only used as a buffer? and will this affect my future transactions.