copy sqlserver analysis database to another server?

How can I copy a sqlserver analysis database from one server to another server?
Lenny GrayAsked:
Who is Participating?
 
Tim HumphriesDirectorCommented:
Hi,

Backup the database, (connect to SSAS within Management Studio and backup from there); create a new, blank database on the new server and then restore over the blank database from the backup.
Maybe there's a neater way, but this has always worked reliably for me.

Tim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.