Skip to Content
Sep 03, 2020 at 09:36 PM

Problems archiving historical data from SAP Business One for SQL in the data archiving option


Dear Our database is 355 GB in size. ERP system performance is low, which is why we need to run SAP business one data archiving option for SQL Server (archive historical data). At the moment of starting the process, it shows us a message that says: "Other users are currently connected to the database". I have validated no users from SAP, SQL, service connected. When we consult our SAP partner B1, he indicates that this option: Data Archiving, does not work (SQL Server / Hana), the truth is that it is hard for me to believe that there is an option which cannot be used. I will be grateful if you can give me the green light in this regard.