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

SQLSaturday Orlando 2021 – September Update

By

Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today...

Audit Columns

By

One of the easiest ways to collect information about table activity is to add...

Daily Coping 28 Sep 2021

By

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

Read the latest Blogs

Forums

Social Media Link Aggrigator

By suvina

Need a way to put all of your social media links and profiles into...

Implicit conversion from datetime to datetime2

By Alessandro Mortola

Comments posted to this topic are about the item Implicit conversion from datetime to...

Connect to SAP HANA Data as a Linked Server

By JerodJ

Comments posted to this topic are about the item Connect to SAP HANA Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers