Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Backup all Analysis Services databases to drive

By RGHippen,

This stored procedure will loop through all of the Analysis Services databases in the repository and back them up to a .cab file using the msmdarch command. A log file will be included with the backup.

There will be 2 days worth of backups saved to a local disk drive on the server.

It may be necessary to add "C:\Program Files\Microsoft Analysis Services\Bin" to the path statement on the server in order for SQL Server to find msmdarch when running the stored procedure as part of a scheduled SQL job.

Total article views: 412 | Views in the last 30 days: 3
 
Related Articles
FORUM

Rename SQL server Server

Rename SQL server Server

FORUM

Server to server backup

Server to server backup

BLOG

SQL Server 2012 ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Serv...

FORUM

SERVER NAME

SERVER NAME

FORUM

VM SERVER

VM SERVER

Tags
 
Contribute