Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

copy sqlserver analysis database to another server?

Posted on 2015-02-04
1
Medium Priority
?
74 Views
Last Modified: 2016-02-18
How can I copy a sqlserver analysis database from one server to another server?
0
Comment
Question by:Lenny Gray
1 Comment
 
LVL 15

Accepted Solution

by:
Tim Humphries earned 2000 total points
ID: 40590579
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question