SQL Server Performance

Archive only structure NOT data

Discussion in 'Analysis Services/Data Warehousing' started by gus, Nov 23, 2005.

  1. gus New Member

    Hi there.

    I'm performing an automatic OLAP DB backup with msmdarch.exe.
    Everything is going well, but what I'm trying to do is to just archive the structure. (to speed up things, I'm afraid also of locking issues )

    If you for example archive a database that is not processed you get only a couple of files in the CAB. ( roles / data source / and a .inf and a .rep )

    This is what I want, only the structure.
    I don't care to have to process the cube if I have to restore it.
    And it's a lot faster the archive this way.
    I mean, I don't want all the aggregation and dims get saved in the CAB, just the structure.

    Anyone knows if it could be done ? and How ?

    Thanx.

  2. Adriaan New Member

    Not hindered by any knowledge of OLAP per se, but can't you just right-click the database, select "Generate SQL Script", and mark all options, except for including the DROP statements.

    You can run this script at any time from Query Analyzer, perhaps changing the database name with a "Find And Replace" action (Ctrl-H in QA, like in Word) and it will create your database from scratch, with no data.
  3. gus New Member

    I forgot to mention that in this case is AS 2000.

    There's no metadata scripting in AS 2000. (what you said could be used in AS2005 though )

    Maybe I should try if there some API in DSO to backup with more options than msmdarch.exe

    Anyone ?
  4. gus New Member

Share This Page