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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-03 : 09:00:53
|
| Pritpal writes "1) How can I backup cubes and their depencies like (Dimensions, Measures etc.) and how can I restore the same to another server. 2) I designed a cube which is linked to a Data Source lets say "CubSource". Now I want to change the name CubSource to "SourceCub" and want that the my cube's data source should also be changed to "SourceCub". How can I do this?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-07-03 : 14:34:31
|
| 1) right click on the database, and select archive.1a) You could also use the metadatascripter which is included in the SQL 2000 res kit. 2) right click on the datasource and edit the properties.-Chad |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-03 : 16:30:17
|
1) You can also schedule daily backups using a batch file running the msmdarch command and run it from a CmdExec sql job stepCheck out the full syntax of msmdarch in BOL["command-path]msmdarch["] /a Server "OLAPDataPath" "DatabaseName" "BackupFileName" ["LogFileName" ["TempDirectory"]]2) You can change the datasource itself however you cannot change the name that appears visible in Analysis Manager as it is hardcoded into the cube structure (which they will hopefully fix this one of these days) unless there are no cubes that reference it (unlikely )HTHJasper SmithEdited by - jasper_smith on 07/03/2002 16:57:24 |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-07-04 : 00:51:18
|
| Chad,Jasper is right, you cant change the name of data source, you have to create new one, replace it with the older and delete the older one.Thats the procedure for renaming the data source.---------------------------Sandesh - The Messanger |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-07-04 : 02:06:54
|
| I was more referring to the actual datasource (Database) the name of the datasource object should be irrelavent. You can change it in the script if you use Metadatascripter to script out your AS Objects.-Chad |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-04 : 04:25:46
|
| I agree it should be irrelavent - and as such you should be able to change the displayed name in Analysis Manager to whatever you want. Quite why it needs to be hard coded into the stuctures based on its display name I do not understand.HTHJasper Smith |
|
|
|
|
|
|
Cubes Backup & Resore