We help IT Professionals succeed at work.

Repair SQL installation question

smythsit
smythsit asked
on
1,896 Views
Last Modified: 2012-05-05
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.
Comment
Watch Question

Commented:
You can backup OLAP databases.

Author

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

Thanks.

Commented:
Connect to your Analysis Services server via Object Explorer, go to Databases folder, right-click on your database and choose "Back Up...".
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Great thanks a lot
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.