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 ««12

SSAS Database Backup Expand / Collapse
Author
Message
Posted Sunday, September 4, 2011 5:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 4, 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
Posted Wednesday, January 18, 2012 7:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 9:50 AM
Points: 36, Visits: 171
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 »

Add to briefcase ««12

Permissions Expand / Collapse