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
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
Hi @Vishu-2318,
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
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.
14 people are following this question.