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

API Information

Can someone direct me to the APi information that would allow me to retrieve
the "Last Run date" of a report as well as the schedule information that
belongs to that report?>From Reporting Services BOL 2005:
Report.ExecutionTime
Gets the date and time that the report was generated.
Namespace: Microsoft.ReportingServices.ReportRendering
Assembly: Microsoft.ReportingServices.Processing (in
microsoft.reportingservices.processing.dll)
C#
public DateTime ExecutionTime { get; }
Regards,
Thiago Silva

API for controlling replication?

Rather than having merge replication performed on a schedule, I need to
programmatically invoke it. Is this possible, and where can I find
documentation about how to do it?
David
That depends on what you are trying to accomplish.
Some people use Windows Synchronization Manager which can be run on users
laptops. It is a little difficult to deploy and doesn't really support SQL
Authentication (it does, but the user will be prompted to enter the password
each time, which makes it impractical). It has limited scheduling.
Then there is the replication activeX controls, which is great, however you
will have to code your own scheduler here. Another problem with it and WSM
is that you can't set many of the properties on the agents.
WSM and ActiveX controls do support Interactive Conflict resolution.
Finally you can use ado to run sp_startjob, which may be your best option as
it is feature rich..
Hilary Cotter
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
"David" <David@.discussions.microsoft.com> wrote in message
news:4E8C6EAB-D8E2-4A30-A393-49D9E8786AAE@.microsoft.com...
> Rather than having merge replication performed on a schedule, I need to
> programmatically invoke it. Is this possible, and where can I find
> documentation about how to do it?
> David
>

Anyway to schedule a report to deploy automatically

Can this be done with ssis or executed in a package?

You only deploy a report when the definition changes. Do your modify your reports on a regular basis? If that is the case then I would suggest writing a little program using the SQL Reporting Services WebServices API. You can do just about anything with it!|||Nevermind, it's the table that is getting updated and the report is already there.