Post reply

OLAP Remote backup

  • August 17, 2011 at 3:15 am

    #148585

    <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

    <Object>

    <DatabaseID>Adventure Works DW</DatabaseID>

    </Object>

    <File>Adventure Works DW.abf</File>

    </Backup>

    I use the above script within a SQL Agent job to backup my OLAP database on a OLAP server which has SQL Server and Analysis services installed

    . I have another server which just has AS installed how do I go about automating backups on this server.

    Can I get the SQL agent job to connect to the server and do a backup.

  • August 21, 2011 at 7:36 am

    #1371156

    Bobby,

    Of course you can, when setting up an Analysis Services Command Job, you apply a value for the server. This is in the form: "Servername\InstanceName". The server can be the localhost or every server accessible by the SQL_Server_Agent process. Be aware that credentials running the job need appropriate rights to do the backup on the remote server.

    Regards Kees

  • August 22, 2011 at 3:33 am

    #1371302

    Thank, but what do I use for the TAG name.

  • August 23, 2011 at 1:31 pm

    #1372242

    See attached doc, this is an example of a SQL-Server-Agent Job step

  • August 26, 2011 at 9:44 am

    #1373890

    Thanks, I did try that I must of been doing something wrong with the server name.

    I'll try again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply