Hi @K. Kong
If you are looking for Azure SQL Database,
As you aware the backups are managed internally by Azure for Azure PaaS SQL database
Automatic backups for these databases run one full backup weekly, differential backup on every 12 to 24 hours interval, and transaction log backup on every 5 to 10 minutes. The first full backup will be taken by Azure as soon as you deploy your Azure SQL database. You don’t need to configure anything for that. Azure does it on your behalf whenever you deploy any SQL database.
However, if you would like to take on demand backup for your database you can import the data in bacpac file.
Here are the steps
Export a database to a BACPAC file - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn
Export via SQL server Management Studio
You can make use SQL Server Management Studio Export data-tier application wizard to export the Azure SQL database to a .bacpac file. The .bacpac can be stored into Azure blob storage or file share.
Right click on the SQL Database on logical SQL Server from SSMS --> Tasks --> Select 'Export data-tier application' wizard.
You can select the subset of the tables from export setting in Advance tab --> Click Next to view the summary of export. One you click finish. And up on completion of the process you will be able to view the BACPAC file in the specified destination.
Let us know if you are looking for additional information.
Thank you!