Re: Cube Archive \ Backup

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

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 12/07/04 

Date: Mon, 6 Dec 2004 16:06:19 -0800

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 ... > The path, file name, and .log extension of the archive log. ... > If you specify an invalid path or file name, ... > The following command archives the sample FoodMart 2000 database ...
    (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)