Share via

Facing an issue while Export/Backup SQL Database

Gravitive Service 0 Reputation points
2025-04-14T10:14:50.65+00:00

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

SQL Server Database Engine
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deepesh Dhake 80 Reputation points
    2026-06-02T04:45:53.7466667+00:00

    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.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.