How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?

2 votes

1 answer

1986 views

sql-server ssas backup powershell data-integrity

                          I have a procedure to backup SSAS Databases  that is working successfully.

I also delete the SSAS backup files that are older than 2 days .

What I am looking forward to implement is:

1) How to verify my SSAS backups? (restore verify only)

2) How to run a DBCC CheckDB in SSAS? (database integrity)

But I have not found any substantial documentation for these.

Any suggestions?

I know about the right-click/ Validate database on Visual Studio but I would like an automated process, not manually clicking.

Asked by Marcello Miorelli (17274 rep)

Dec 1, 2014, 12:51 PM
Last activity: Jul 27, 2022, 02:00 PM

How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?

Related Questions