Re: Moving large cubes

#1

Are you sure that you can't archive the database?
The limitation is that no *ONE* file can exceed 4GB. Not that the total size
can't exceed one cab file. The utility will create more than one cab file if
it is needed. The limitation is that for cab file technology, files cannot
span more than one file.

Secondly if you don't have the edit connection string option on your AM
menu, then you aren't running SP3 (it was added in SP3).
I strongly recommend that you upgrade your server to SP3 (which has been out
for well over a year now).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"yongli" <yongli (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have no idea how this could be done. Maybe you should copy the
respository over (in addition to the data folder), but without SQL server

interface, I don't know which files you should copy over, plus, this is like
whole system backup and restore procedure (from machine A to machine B), not
just copy one database, is this what you want?

Quote:

"PNT" wrote:

Yongli,

The source and destination machines are in two different physical
locations with no network connectivity. Data transfer can occur only via FTP

or physical medium.

Quote:

I cannot map the 2 machines onto Analysis Manager and copy the objects.

Please help. Thanks.

"yongli" wrote:

Try following steps (on target machine):

1. Copy the cube structure (via copy/paste from Analysis Manager)
2. Copy over the data folder
3. Copy over the .ODB file
4. Recycle AS2K service.

"PNT" wrote:

I was looking at the reply by Dave Wickert [MSFT] and he suggested
reading the *extensive* section on backup and restore in the AS Operations

guide. I have already browsed that and it does not help.

Quote:

I have tried using the "Copy and Move files" method by Migrating the
Repository. I dont have an option to "Edit the Repository connection string"

on the destination machine. I just have the "Migrate Repository" option. So
how do I make the destination machine look at the new repository?

Quote:

"PNT" wrote:

I have a 4GB processed cube. I need to move this cube to another
machine. I cannot use "Archive and Restore" as the size of the cube is more

than 2GB. I dont want to move the fact and dimension tables and process the
cube again as this takes about 80 hours.

Quote:

Please help! Thanks in advance

PNT

#2

Normally a restore of an archived database does not require a reprocess --
unless the database was in a state which was required a reprocess when it
was archived, or if you inadverently did something, such as doing a full
process of a non-changing dimension which will force a full reprocess.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"PNT" <PNT (AT) discussions (DOT) microsoft.com> wrote

Quote:

Dave,

That was it, I had to install SP3 to get the "edit repository string"
option. I was able to move the processed cube from machine A to machine B

and machine B can see all the fact and dimension tables. But I have a new
problem now. I am being asked to process the cube again!! The whole point of
this copy and transfer was to avoid reprocessing the cube (which takes 80
hours). Am I missing something here?

Quote:

Please help!

P.S: Yes, I am not able to archive the database since I have one partition
file which is 4.1GB is size. I was not able to create multiple partitions

since I have the standard version of SQL server and not the Enterprise
version.

Quote:

"Dave Wickert [MSFT]" wrote:

Are you sure that you can't archive the database?
The limitation is that no *ONE* file can exceed 4GB. Not that the total
size
can't exceed one cab file. The utility will create more than one cab
file if
it is needed. The limitation is that for cab file technology, files
cannot
span more than one file.

Secondly if you don't have the edit connection string option on your AM
menu, then you aren't running SP3 (it was added in SP3).
I strongly recommend that you upgrade your server to SP3 (which has been
out
for well over a year now).
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"yongli" <yongli (AT) discussions (DOT) microsoft.com> wrote in message
news:238C9242-CD47-4F76-9DD6-66C494B4CE76 (AT) microsoft (DOT) com...
I have no idea how this could be done. Maybe you should copy the
respository over (in addition to the data folder), but without SQL
server
interface, I don't know which files you should copy over, plus, this is
like
whole system backup and restore procedure (from machine A to machine B),
not
just copy one database, is this what you want?

"PNT" wrote:

Yongli,

The source and destination machines are in two different physical
locations with no network connectivity. Data transfer can occur only via
FTP
or physical medium.
I cannot map the 2 machines onto Analysis Manager and copy the
objects.

Please help. Thanks.

"yongli" wrote:

Try following steps (on target machine):

1. Copy the cube structure (via copy/paste from Analysis Manager)
2. Copy over the data folder
3. Copy over the .ODB file
4. Recycle AS2K service.

"PNT" wrote:

I was looking at the reply by Dave Wickert [MSFT] and he
suggested
reading the *extensive* section on backup and restore in the AS
Operations
guide. I have already browsed that and it does not help.
I have tried using the "Copy and Move files" method by Migrating
the
Repository. I dont have an option to "Edit the Repository connection
string"
on the destination machine. I just have the "Migrate Repository" option.
So
how do I make the destination machine look at the new repository?

"PNT" wrote:

I have a 4GB processed cube. I need to move this cube to
another
machine. I cannot use "Archive and Restore" as the size of the cube is
more
than 2GB. I dont want to move the fact and dimension tables and process
the
cube again as this takes about 80 hours.

Please help! Thanks in advance

PNT

#3

Just curious about something that does not seem to add up - you're
competing against Oracle and Cognos (not ultra cheap), want to show SQL
Server in a non "rinky-dinky" light, have a large (4 GB) cube. And yet -
you're using Standard, rather than Enterprise Edition, with a single
partiton! Can't Enterprise Edition easily be justified?

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Moving large cubes

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Moving large cubes - 07-16-2004 , 01:04 AM

Re: Moving large cubes - 07-19-2004 , 12:34 AM

Re: Moving large cubes - 07-19-2004 , 06:03 PM