anybody help me please..... i need to know how to create an autumated job in analysis services to take backup of analysis services databases in MS Sql server 2005 Thanks in Advance Yukon DBA
You use sql agent to job to automate the AS backups and you can use also nt scheduler with ASCMD utility... http://msdn2.microsoft.com/en-us/library/ms365187.aspx
I believe you could use SQLAgent tasks to automate the backup processes. http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx & http://technet.microsoft.com/en-us/library/ms174874.aspx too.