We would probably need more details on this request as to the planned next steps for the backup file and the issue/need that generated the question.
There are no "automatic backups" of the Sage CRM data done by CRM itself, if that is in question here.

There may be some backups done automatically in your environment, such as a virtual machine snapshot for the server where Sage CRM is installed or where SQL is installed.

Below is information on backing up Sage CRM data that you may implement in your environment.  Once backing up is done, then you would have a backup file, per your question.

There are several factors involved in backing up CRM data (including the database itself in SQL and Sage CRM installation folder files).

The Sage CRM System Administrator Guide has information available on https://help.sagecrm.com/.

(Direct link to System Administrator Guide: https://help.sagecrm.com/pdf/2025R1+/SageCRM_SystemAdminGuide_EN.pdf)

The section on Server administration contains:

-Scheduling a database backup task

-Setting up a database maintenance plan

-Overview of manual backups

-Backing up the database manually

-Backing up the registry manually

-Backing up program files manually 

Backing up the CRM SQL database itself would be done via SQL. You will want to have your SQL DBA involved in the process to confirm the steps and the correct database locations and you may want to consult with your Sage Partner or CRM Consultant for assistance.

Note: if this suggested answer helped, please mark it as verified  (by clicking the "…" button next to Reply, on the response) for the benefit of others in this forum. Thank you!