SQL Analysis Services database

Question

Experts , Please guide if we can take an incremental backup also for an SQL Analysis database or is it full backups only for restoration on to another Analysis instance

Answer 1

Hi @Vishu ,

Only full backup is supported to back up the SQL Analysis Services databases, so we couldn't take an incremental backup.

If you want to add new data to the database, you may process the database and then do full backup.

Details for your reference:

process-database-table-or-partition-analysis-services

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

SSAS, both multi and tabular mode, supports "only" full backups, see Backup and Restore of Analysis Services Databases

full backups only for restoration on to another Analysis instance

Or on the same server, e.g. if data processing fail or on an outtake, which cause a database failure.