question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked OlafHelper-2800 answered

SQL Analysis Services database

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

sql-server-generalsql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.