This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
My SQL Server Database backups are taking 24 hours or more to backup a 350 GB database. Why does this take so long?Also, we are running the export on a copy of the Database (made using Azure Copy), so it is isolated from impact from daily workload.
Location: South Central US
Standard Gen 5 with 4 vCores and 380 GB allocated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi George Tetterton,
We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Using the information in the Question you sent I am in the process of creating clustered indexes on my large table which did not have clustered indexes. I was under the impression that any field defined as IDENTITY would automatically get clustered index, which apparently was incorrect after doing some internet digging. We can close this question as a duplicate if that is the protocol here.
Hi George Tetterton,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
Please refer to similar Q&A post if this is helpful https://learn.microsoft.com/en-us/answers/questions/483441/is-there-a-faster-way-(than-bacpac-export-import)
Please let us know if your ask is different.
Thank you.