Can LiteSpeed backup and restore Analysis Service databases in SQL Server 2000 or SQL Server 2005?
RESOLUTION:
Analysis Services uses an OLAP cube.LiteSpeed does not backup OLAP cubes.
The native SQL Server command prompt: run from C:\Program Files\Microsoft Analysis Services\Bin>
Msmdarch.exe /A VMAnalysis "\\vmanalysis\c$\program Files\Microsoft Analysis Services\Data"
olapdb_manual c:\backup\olapdb_manual_bak
Where 'VMAnalysis' is the Analysis server name
"\\vmanalysis\c$\program Files\Microsoft Analysis Services\Data” is the data folder olapdb_manual is the OLAP database c:\backup\ is the backup folder olapdb_manual_bak is the backup file name
This command would take a backup of the OLAP database olapdb_manual from the analysis server, VMAnalysis.
For additional information: http://www.databasejournal.com/features/mssql/article.php/3567131
