Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TimChenAllen
Starting Member
45 Posts |
 Posted - 2003-12-03 : 03:28:38
|
| Is there a quick way to make a cube or a dimension be not processed? I have a couple of reasons to do this:1) Force the processing of a virtual cube to also process its base cubes.2) Make the database not have any actual data so Archiving the database will go very rapidly and produce a very small archive file.Thanks in advance.--TimothyAllen[url]http://www.timallen.org[/url] |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-09 : 03:38:10
|
| I found a solution for speeding up the Archiving of a Database: Copy the database to a temporary database:1) Copy the database to a temporary database: from Analysis Manager, right click the database and select "Copy", then right click the server and select "Paste". Change the name of the new database.2) Right click the new database and select "Archive Database".--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
 |
|
|
|
|
|
Make a cube or dimension be not processed