I am fixing an issue with our automated Analysis Server backups. We use SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS to get the catalog name, and then plug that into our t-sql to do a backup. The script puts the catalog name into the DatabaseID XML for the backup. The issue is, for some of the cubes, the catalog name and the database id are not the same. So, that cube does not get a backup. We can't rename the cube, and changing the ID is troublesome, so, is there a way to get the database id, using T-SQL? I can use SSMS, and look at the properties, and it shows the ID, but I don't know how SSMS is retrieving that value.
Thanks,
Leonard