SQL Server Performance

backup and restore

Discussion in 'Analysis Services/Data Warehousing' started by california6, Feb 20, 2008.

  1. california6 New Member

    I am issuing the following backup command for AS - Cube and some how it doesnt work. The cube database is residing on a different server.
    c:program filesanalysis serverinmsmdarch /a DEV "e:Microsoft Analysis ServicesData" "Prod" "d:prod112.cab"
    In the above case - i am running the backup database from my dev machine against prod server. some how it doesnt work and i dont see any error message? I was curious if this works or not?
    appreciated any input on this.
    Thanks,
  2. satya Moderator

    How about privileges (both on SQL & Operating system) for the SQL account from Dev. server to production server?
  3. california6 New Member

    I am using a common account for both servers and this account has all the privileges on both servers
    My question: Is it possible to backup Cube database from a different server not the actual server?

Share This Page