Re: Cube Archive \ Backup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

benaud_at_gmail.com
Date: 12/07/04 

Date: 6 Dec 2004 21:45:47 -0800

Dave Wickert [MSFT] wrote:
> See the following information from BOL -- Yes, you need double
quotes.
>
> Syntax
> ["command-path]msmdarch["] /a Server "OLAPDataPath" "DatabaseName"
> "BackupFileName" ["LogFileName" ["TempDirectory"]]
>
> command-path
>
> The path containing the msmdarch.exe file. By default, this path is:
>
> C:\Program Files\Microsoft Analysis Services\Bin
>
> Server
>
> The server computer name that contains the database you want to
archive.
>
> OLAPDataPath
>
> The path of the Data directory that contains the files for the
database you
> want to archive. By default, this path is:
>
> C:\Program Files\Microsoft Analysis Services\Data
>
> DatabaseName
>
> The name of the database you want to archive.
>
> BackupFileName
>
> The path, file name, and .cab extension of the archive file.
>
> LogFileName
>
> The path, file name, and .log extension of the archive log. If you
specify
> an archive log that already exists, the new archive log is appended
to it.
> If you specify an invalid path or file name, the archive log is
written to
> the DBArchive.log file, which by default is C:\Program
Files\Microsoft
> Analysis Services\Bin\DBArchive.log.
>
> TempDirectory
>
> The specified path of the temporary directory used for processing
space.
> This option must be specified if LogFileName is specified.
>
> Sample:
>
> The following command archives the sample FoodMart 2000 database
included in
> Analysis Services.
>
> "\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a myserver
> "\Program Files\Microsoft Analysis Services\Data\" "FoodMart 2000"
> "\My archives\server myserver\FoodMart 2000.cab"
>
>
>
>
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
> news:OuBoSl92EHA.480@TK2MSFTNGP10.phx.gbl...
> > Sounds interesting - I simply cannot get the synthax to work
though....
> >
> > In the example it says to put "" around the parameteres - does this
apply
> > when being run in a dos prompt ? Tried thsi sentence but
> > nothing happens - no error - no backup - no nothing...
> >
> > msmdarch /a localhost c:\program files\microsoft analysis
> > services\data\foodmart 2000 foodmart.cab
> >
> > ....and then tried this
> >
> > msmdarch /a localhost "c:\program files\microsoft analysis
> > services\data\foodmart 2000" foodmart.cab
> >
> > /Michael
> >
> > "Dan Reving" <dan.reving@magasin.dknospam> wrote in message
> > news:e1EmIT72EHA.2192@TK2MSFTNGP14.phx.gbl...
> > > Hi Brett
> > >
> > > MSAS is supplied with a command line tool, msmdarch.exe, for this
> purpose.
> > > (it is located in the directory \Program Files\Microsoft Analysis
> > > Services\Bin\)
> > >
> > > It can easily be incorparated in a cmd/bat-file and thus
automated,
> which
> > I
> > > have done myself.
> > >
> > > Documentation about the tool is contained in the SQL Server books
> Online.
> > >
> > > The tool can - as the online facility in Analysis Manager - only
archive
> > an
> > > entire database. There is no functionality to archive parts of a
> database
> > > e.g. a cube. This makes sense, when you consider the MSAS data
> structure.
> > >
> > > I wouldn't recommend, that you merely backup the datafolder.
Unless you
> > stop
> > > the MSAS-service, you can't be sure, that all files in there are
closed.
> > You
> > > therefore run a significant risk of not backing everything up or
even
> > worse,
> > > that you get an inconsistent backup. Besides this, the archive
facility
> > > (online or command line) heavily comresses your data (it makes a
> > cab-file),
> > > so the archive is significantly smaller than your actual data.
> > >
> > > Best regards
> > > Dan Reving
> > >
> > > "Brett Martin" <BrettMartin@discussions.microsoft.com> skrev i en
> > meddelelse
> > > news:DA77D210-22D8-48F4-861A-7E989406CB33@microsoft.com...
> > > > Has anybody found a way to automate this, or is it just a
matter of
> > making
> > > > sure that the analysis services data folder is backed up?
> > > >
> > > > Cheers
> > > >
> > > > Brett.
> > >
> > >
> >
> >

Relevant Pages

  • Re: Cube Archive Backup
    ... The server computer name that contains the database you want to archive. ... The path, file name, and .log extension of the archive log. ... If you specify an invalid path or file name, the archive log is written to ... The following command archives the sample FoodMart 2000 database included in ...
    (microsoft.public.sqlserver.olap)
  • Re: Huge database weighs heavily on small brain
    ... and controlling the data via the query criteria. ... your idea of replicating the subforms over and over ... > My database has too many subforms on too many levels. ... > database, or create a new database for the Archives, I must link them to the ...
    (microsoft.public.access.forms)
  • RE: Research Journal/To-Do Items/Excel sheet/Template??
    ... When I go to archives and/or get database entries online for possible ... Let's say I plan a trip to Polish archives in, say, Poznan, Pila, Leszno, ... It occurred to me to make a simple Excel sortable database with columns ...
    (soc.genealogy.jewish)
  • Huge database weighs heavily on small brain
    ... The size of what you actually have to backup or archive ... that database applications built using Access be built. ... >My database has too many subforms on too many levels. ... >database, or create a new database for the Archives, I ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... Subforms behave quite nicely. ... form in the original Master Form? ... This database contains dozens of Tables and hundreds of Fields. ... >> database, or create a new database for the Archives, I must link them to ...
    (microsoft.public.access.forms)