Archive only structure NOT data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Archive only structure NOT data

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.
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.
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 ?

I’ve found a starting point to getting the metadata. Anyway it’s all done by hand. Not thru DSO. It can’t seem to find an option in DSO to do the backup…