How does one backup more than one Analysis Service Databases An example that I saw for one Database is using a Sql Server Analysis Services command like this one for Database OLAP: <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>OLAP</DatabaseID> </Object> <File>OLAP.abf</File> <AllowOverwrite>true</AllowOverwrite> </Backup>
http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Hi Satya I read that document link and if I understood it correctly it only discusses how to back up one database at a time and not what I am trying to do. For example if I have 2 databases OLAP and OLAP2 I want to be able to do something like : <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>OLAP</DatabaseID> </Object> <File>OLAP.abf</File> <AllowOverwrite>true</AllowOverwrite> <Object> <DatabaseID>OLAP2</DatabaseID> </Object> <File>OLAP2.abf</File> <AllowOverwrite>true</AllowOverwrite> </Backup> When I tried it, it gave errors .......... Regards, CMT
What was the error? In this case you can input the 2 files stating each of those databases. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.