SSAS Database Backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Dinesh Asanka » SSAS Database Backup

12 posts, Page 2 of 2

««1 2

SSAS Database Backup

Rate Topic

Display Mode

Topic Options

Author

Message

syed.sherfudeen

Posted Sunday, September 04, 2011 5:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, September 04, 2011 5:43 AM
Points: 1, Visits: 2

Also you can change the Dir as per your wish and file name to without overwriting the DB for archive purpose.you can maintain xml config file for dynamic purpose

Post #1169717

t_ciossu

Posted Wednesday, January 18, 2012 7:50 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 8:48 AM
Points: 36, Visits: 132

Hi,
I tried to backup 3 SSAS dbs from the same job step, by creating consecutive XML tags in the same command and if failed. Does anyone know if @command is forced to a single backup command?
This is what code I've used
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>SSAS_DB_NAME</DatabaseID>
</Object>
<File>\\share_path\\SSAS_DB_NAME.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>

Question is if I can do like 3 backups from the same command in one job agent step.
Thanks!

Post #1237984

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions