archiving analysis server dbs

[tim groulx]

Hello,

Does anyone know of a way to schedule the archiving of analysis
databases? Seems pretty lame if you can't... The only answer I've gotten
is "maybe in Yukon"....

Thanks.



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[Simon Hayes]

Re: archiving analysis server dbs

tim groulx <timgru@verizon .net> wrote in message news:<40c7a141$ 0$7885$c397aba@ news.newsgroups .ws>...[color=blue]
> Hello,
>
> Does anyone know of a way to schedule the archiving of analysis
> databases? Seems pretty lame if you can't... The only answer I've gotten
> is "maybe in Yukon"....
>
> Thanks.
>
>
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

Since you use a command-line tool (msmdarch.exe) to archive databases,
you can just schedule that using the job scheduler. Either wrap it in
a batch file, put it in a DTS package (that's useful, because you can
then process the database before archiving), or build it into some
sort of script or program that you write yourself.

See "Msmdarch Command" in Books Online for the full syntax.

Simon