May 24, 2005 at 10:33 am
Does anyone have any slick ideas for backing up Databases in Analysis Services. I have this batch file which will create a good .cab backup. However, for some reason I can not schedule this task successfully. Does anyone have any other methods short of simply backing up the data directory? Here is my current batch. The simple thing would be to figure out why it fails as a scheduled task.
msmdarch /A NBROLP01 "D:\Program Files\Microsoft Analysis Services\Data\" "Sales" "D:\OlapBackup\Sales.cab" "D:\OlapBackup\OlapBackup.txt" "D:\"
May 24, 2005 at 9:39 pm
It's possible that the batch fails because the user context that it's executing under isn't a member of the OLAP Administrators group on the AS server.
Steve.
May 25, 2005 at 7:26 am
The account the job runs under is both a local admin and olap admin on the server.
May 25, 2005 at 7:47 am
You may have to add "C:\Program Files\Microsoft Analysis Services\Bin" to the PATH statement on the server in order for SQL Server to find msmdarch.
I have submitted a stored procedure to the Resources > Scripts area on this site which creates a backup of each Analysis Services database by looping through the database names in the repository.
This works especially well on a test server when you need to quickly get back to a previous version of an Analysis Services database.
May 25, 2005 at 10:08 am
Can you please the link to your script. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply