Facing an issue while Export/Backup SQL Database

Question

While taking backup of an existing SQL Database using Export Database option, observed that its taking too much times in hours. After 3-4 hrs as well its showing progress of just 1% only.

So want support for the same that what could be the reason behind the same to ensure smooth database export / backup and to avoid any un-expected issue related same.Some reference details:

Operation       : ExportDatabase

OperationId     : 73225af3-2313-42d8-b830-ae5692da2c3f

State           : InProgress

StartTime       : 4/14/2025 7:28:19 AM

PercentComplete : 1

Answer 1

Assuming you are using Azure sql database,

1. BACPAC export is not a transactionally-consistent backup. It's a logical export (schema + data), genuinely different from a real backup.
2. For Azure SQL Database, automated backups with point-in-time restore exist and are the right recovery mechanism.
3. Exporting from a database copy gives you consistency.
4. The PercentComplete value is coarse and unreliable.