SQL 2000 Server\Analysis SP3
Windows 2000 SP3
OLAP databases are stored in a MOLAP structure
I have a scheduled job that backs up the OLAP database daily using the msmdarch.exe utility. Its been running successfully since our implementation of SQL Server Analysis last year. It has recently failed.
I've went directly on Analysis Services and attempted to archive the database through the UI interface and received the following error:
"one of the data files is too large to be stored inside a .cab file"
The file that the error is referencing is over 2.1 GB in size.
Has anyone ran into this issue? If so, please point me to the right direction. I need a temporary resolution until I'm able to test and apply long term solutions.