mardi 2 décembre 2014

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


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.


enter image description here





Aucun commentaire:

Enregistrer un commentaire