 | |
Copying Cube data from one server to another
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Copying Cube data from one server to another -
09-05-2003
, 10:34 AM
|
-----Original Message----- I have just been using developing and using our data warehouse for a little over a year. We are now moving all of our databases and applications from Server (A) to Server (B). They are both running Windows 2000. I have had no problem backing up the DBs detaching them from Server (A) and then attaching them to Server (B) but have no clue on what to due with the CUBE architecture. The backup and restore for Data Warehousing/Cubes does not seem to be as clear??? Can anyone help me? Any assistance in this matter would be greatly appreciated. Thank you in advance Patrick . |
#2
| |||
| |||
|
|
-----Original Message----- old server - right click the cube database - choose archive new server - right click server name and choose restore database. then you just have to process all cubes - Hutch -----Original Message----- I have just been using developing and using our data warehouse for a little over a year. We are now moving all of our databases and applications from Server (A) to Server (B). They are both running Windows 2000. I have had no problem backing up the DBs detaching them from Server (A) and then attaching them to Server (B) but have no clue on what to due with the CUBE architecture. The backup and restore for Data Warehousing/Cubes does not seem to be as clear??? Can anyone help me? Any assistance in this matter would be greatly appreciated. Thank you in advance Patrick . . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.