Difference between SAP Business One Backup and Microsoft SQL Server Backup.

As a database administrator, “Backup” is my watch word!
It is an important database management and maintenance task. Backup is an exact copy of a database/program at a point in time. Hence, a backup can be restored as the original database in case of disaster or database maintenance.
SAP Business One is an ERP system that sits on a number of database systems which includes Microsoft SQL Server, IBM DB2 and Sybase.
For the purpose of this discussion, the emphasis is on Microsoft SQL Server.
It is worth mentioning that SAP Business One has a traditional backup utility called the SBO Backup Service.



Microsoft SQL Server also has its own backup tool resident in the enterprise manager.



The crux of the matter therefore is the basic difference between using the SAP Business One backup tool and the Microsoft SQL Server Enterprise manager backup tool.
A distinctive capability makes the SAP Business One Backup service a preferred backup tool over the Microsoft SQL Server backup Engine.

The SAP Business One backup tool backs up the database and the directories defined in General Settings while Microsoft SQL Server backup tool only backs up the database as shown below



SAP Business One Backup Contents


Microsoft SQL Server Backup Content


Conclusively, it is important to state that, to restore either of the backup types, the Microsoft SQL Server Enterprise Manager is used and the content of the directories (SBO Backup) must be manually copied to the respective directories.