<div>
You can backup OLAP databases.
</div>


<div>
Can you tell me how to back up an OLAP database?<br />
<br />
Thanks.
</div>


Can you tell me how to back up an OLAP database?

Thanks.

<div>
Connect to your Analysis Services server via Object Explorer, go to Databases folder, right-click on your database and choose &quot;Back Up...&quot;.
</div>


Connect to your Analysis Services server via Object Explorer, go to Databases folder, right-click on your database and choose "Back Up...".

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm trying to find out if repairing a sql installation or reinstalling sql server will have an affect on my analysis services?<br />
<br />
Can you detach a cube like you can detach a database?<br />
<br />
We just have a problem that might need a repair/reinstall and i don't want to affect our reporting cube.<br />
<br />
Thanks,<br />
Alan.
</div>
</div>


Hi,
I'm trying to find out if repairing a sql installation or reinstalling sql server will have an affect on my analysis services?

Can you detach a cube like you can detach a database?

We just have a problem that might need a repair/reinstall and i don't want to affect our reporting cube.

Thanks,
Alan.

Repair SQL installation question

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.