This is a discussion on archiving analysis server dbs within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, Does anyone know of a way to schedule the archiving of analysis databases? Seems pretty lame if you ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. Simon |
| Thread Tools | |
| Display Modes | |
|
|