Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

xmla script for automate ssas database backup Expand / Collapse
Author
Message
Posted Tuesday, October 5, 2010 8:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 2, 2010 1:31 AM
Points: 24, Visits: 54
Hi

WE want to write one xmla script to take backup of all ssas data base in production envirnment to take back up in on go So we don't need take back up one by one .

I am new in xmla .Please guide me to write script for this requirement .Sample of script will kelp me to move forward .

Regards,
Alok
Post #998908
Posted Tuesday, October 5, 2010 8:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:02 PM
Points: 2,918, Visits: 2,518
I find that the easiest way to get started with XMLA is to look at examples and the easiest way to get some examples is to use Management Studio. Most (maybe even all) of the activities that you can do by right clicking have the option to script the XMLA for the task you are trying to perform.

e.g. to backup a database, I right clicked, selected backup, de-selected "Encrypt back file", scripted the result which looked a bit like
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Your database name</DatabaseID>
</Object>
<File>Your back filename.abf</File>
</Backup>

Your next best resource is to use Books Online which you should have installed onto your workstation. Search for XMLA in the index and start reading.



Post #998911
Posted Tuesday, October 5, 2010 9:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 2, 2010 1:31 AM
Points: 24, Visits: 54
Hi Thanks to reply that is really helpful to learn .

But i am stuck to write one xmla script that will take back up for all ssas database in one go , It's straight forward to write script for one data base or we can easily see in management stdio .

Any ideal to write or join xmla script for number of data base will helpful to save my a lot effort .

Thanks & Regards,
Alok
Post #998918
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse