0

Is there a way to reduce BAM Archive database size? We are currently moving the data from BAM Primary DB to BAM Archive. But now BAM Archive DB contains large amount of data which takes huge space. I tried using Biztalk Terminator for this but DB is not getting connected on BT

jarlh
  • 42,561
  • 8
  • 45
  • 63
omkar patade
  • 1,442
  • 9
  • 34
  • 66
  • Which dbms are you using? (This isn't really related to ANSI/ISO SQL...) – jarlh Nov 10 '22 at 14:08
  • @jarlh BizTalk databases will always be Microsoft SQL Server – Dijkgraaf Nov 10 '22 at 18:40
  • 1
    One of the things to check is to see if you have a lot of tables ending with _Failed in your BAM Archive. If you do, you can drop these tables. Other than that you may have to alter how long to retain data in the BAM archive, I'll see if I can dig those commands up. This is not really a programming question, more a server maintenance question. – Dijkgraaf Nov 10 '22 at 18:44

0 Answers0