This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Hi All i have the following query as a part of the SSAS Backup in my Agent job. This is for SQL Server 2008,
Can someone please help me what changes i need to do to make it work on different server (higher versions)?
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>CUBENAME</DatabaseID>
</Object>
<File>CUBENAME.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Have you encounter any specific error ?
Seems there isn't much to change in your code. Which version are you planing to go to ?
SQL Server 2014.
Thanks
Then, the old script should work.
I checked the code in my 2019 environment, it works.
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>cubename</DatabaseID>
</Object>
<File>cubename.abf</File>
</Backup>
I think the code is OK, have you resolved your problem?
Thanks for the confirmation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
That same command should still work on the current engine. Are you seeing an error of some sort when you try to run it?
Thanks dgosbell, it says 2003 engine in the code, i didnt run it yet, but current version is sql server 14.0
There never was a SQL Server 2003, that is just the xml namespace, it's like an API version. That command should work fine as it is.