Technical Article

Backup all Analysis Services databases to drive

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 […]

2007-06-07 (first published: )

423 reads

Blogs

Daily Coping 20 May 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 19 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

Running Trace - Error: Login timeout expired

By ramana3327

Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...

query perf issue

By siri_28

Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...

Looking for some guidance on avoiding Scalar UDFs for DB lookups

By SteveOC

Hello. I am not a SQL Developer - just an IT generalist (if that)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers