archiving analysis server dbs

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!tim groulx <timgru@.verizon.net> wrote in message news:<40c7a141$0$7885$c397aba@.news.newsgroups.ws>...
> 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!

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.

Simonsql

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
applied together, one before the other, not at all?
Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:

> Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
> applied together, one before the other, not at all?
> --
>
|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should b
e
applied together, one before the other, not at all?
--Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:

> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
be
> applied together, one before the other, not at all?
> --
>|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>

Applying sp4 advice on a server with sql and analysis services

Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
applied together, one before the other, not at all?
--Hi Burt
It is usually better to keep everything in step, and I would apply the
engine first.
John
"burt_king" wrote:
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should be
> applied together, one before the other, not at all?
> --
>|||You can apply them in any order. With SP1 you would need to apply them
together IIRC.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"burt_king" <burt_king@.yahoo.com> wrote in message
news:96F2A6C3-00AA-4BC3-A49D-0294B9B8CC60@.microsoft.com...
> Can anyone tell me if sp4 for analysis services and SQL server 2000 should
> be
> applied together, one before the other, not at all?
> --
>