Problema con Backup Automatico en Azure Analysis Services

Question

Buenos días.

Hemos desarrollado un sistema de Backups para Azure AS.

El caso es que tengo una BBDD Tabular que tarda 1 hora aprox en hacer el backup pero cuando lo programo se queda durante horas y horas ejecutando y no termina.

Sabéis si puede deberse a alguna conexión que esté hecha o se haga mientras se hace el backup?

En caso de que sea así hay forma de poner la BBDD en modo exclusivo o algo similar?

Un saludo.

Answer 1

Hello Héctor Fernández,

It is possible that the backup process is taking longer than expected due to connections being made to the database while the backup is running. This can cause the backup process to slow down

My understanding is Analysis Services doesn’t have an exclusive mode like SQL Server. To minimize the concurrency activity, consider pausing any scheduled data refreshes, queries, or other activities that might interfere with the backup process.

Please monitor the AAS metrics during the backup process and see what is causing the issue. See the below document for more details. https://learn.microsoft.com/en-us/azure/analysis-services/monitor-analysis-services

I hope this helps.