Re: Error while arching DB in analysis services

#1

Sean

I have another type of issue on using "restore". If I try to restore some
databases from CAB files, it appears to work successfully. But when I try
and open a cube I get a message saying "Unable to locate cube XXXX". Looking
at the directory, all the files have been successfully unarchived, and the
catalog, cubes and dimensions all appear in Analysis Manager with a status
of "processed".

To make things worse, the cubes are still NOT available even if I reprocess
the entire catalog. The only way to resurrect the system, is to copy the
catalog and paste it as version 2. Then reprocess.

Do you have any ideas why this is so.

Thanks

Avi

PS: The problem is inconsistent, as some catalogs restore without issue
while others don't. As a further measure, I have also tried migrating the
repository to SQL SVR, and it has no effect on the outcome.

"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote

Quote:

For backing up and restoring cubes of this size I would consider the
following alternative.

As an alternative to using the Archive/Restore utility, you could do the
following:

1.. Stop the MSSQLServerOLAPService
2.. Use a backup utility like NT Backup to make a backup of the entire
OLAP Data folder and all it's sub-folders.
3.. Make a backup of the OLAP repository (If the repository is in the
msmdrep.mdb file, make a backup of the msmdrep.mdb file. If the repository
has been migrated to SQL Server, which I would recommend, make a SQL
Backup
of the database. If you plan to restore to another server, the OLAP
repository should not reside in the MSDB database.).
4.. Re-start the MSSQLServerOLAPService

This effectively creates a backup of all of the data for the Analysis
Server. You can then restore the entire Analysis Server data structure by:

1.. Stop the MSSQLServerOLAPService
2.. Use a backup utility like NT Backup to restore the data folder from
backup
3.. Restore the OLAP repository from backup
4.. Re-start the MSSQLServerOLAPService.

Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"techie500" <parthi500 (AT) yahoo (DOT) com> wrote in message
news:05b101c36759$bb725b50$a101280a (AT) phx (DOT) gbl...
Just to correction to my below mail, it is NOT SP3, it is
SP2..
-----Original Message-----
Hi,
To add further info to my issue..
One of the file to be archived is 2.6GB. Server has SP3.
If this is the limitation, any workaround pls...
thanks
Parthiban

-----Original Message-----

Hi,

When we tried to archive one of the database in analysis
manger, it
gives the error message as 'One of the data file is too
large to be
stored inside a .cab file'. The total cube size under
the database is
3615 MB. so Is there any limitation for .cab file in AS
while archiving
database..?

thanks,

techie500

--
Posted via http://dbforums.com
.

.

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

Re: Error while arching DB in analysis services

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

Re: Error while arching DB in analysis services - 09-10-2003 , 12:16 PM