Other SQL Server Blogs around the Web

Automation of Analysis Services database backup

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple, within SQL Server 2005 version you can schedule BACKUP/RESTORE commands to execute on schedule using SQL Server jobs. SQL Server 2005 has a new job step type -- Analysis Services command -- which allows you to execute XMLA statements, including BACKUP...(read more)

Read the complete post at http://sqlserver-qa.net/blogs/bi/archive/2007/09/26/automation-of-analysis-services-database-backup.aspx

This Blog

Syndication



© 2000 - 2007 vDerivatives Limited All Rights Reserved.