SQL Server Performance Forum – Threads Archive

BackingUp Multiple Analysis Service Databases

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.

---

Hi, Please give example of what you mean. Regards,
CMT

---

]]>