Post reply

Any of you have done Analysis Server 2000 Service backups

  • May 10, 2007 at 8:43 am

    #178497

    Hi,

    Any of you have worked on taking analysis services backup for 2 days and delte older backups. I know how to do for Database, but struggling arround for how to do for Analysis Services.

    Thanks for Sugestion, Support.

    Regards,

    Rajesh

  • May 13, 2007 at 1:09 pm

    #706064

    http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx

  • May 14, 2007 at 7:01 am

    #706204

    Using SQL 2000

    Backup

    "C:\program Files\Microsoft Analysis Services\BIN\msmdarch.exe" /a ServerName "E:\program Files\Microsoft Analysis Services\Data" "DatabaseName" "E:\DBBACKUPS\olap\DatabaseName.CAB" "E:\DBBACKUPS\olap\DatabaseName.log"

     

    Restore

    "C:\program Files\Microsoft Analysis Services\BIN\msmdarch.exe" /r ServerName "E:\program Files\Microsoft Analysis Services\Data" "DatabaseName" "E:\DBBACKUPS\olap\DatabaseName.CAB" "E:\DBBACKUPS\olap\DatabaseName.log"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply