How to move SSAS tabular instance databases?
1
vote
1
answer
1122
views
We have a SQL Server 2012 SSAS tabular instance in our environment that is sitting in domain1. We need to move these SSAS databases in a different SQL server 2012 that is on domain2 which has no trust established with domain1. This is the first time I am tasked to move SSAS in to another server. What would be a good approach in moving these SSAS tabular databases? Is a normal backup and restore would do the process? Or does it have to be attach detach process? Also, when I migrated our SQL Server databases, I have to adjust each account logins since there is not trusts between domains. Do I have to do the same thing with SSAS in this case?
Asked by Keith Rivera
(617 rep)
Jul 16, 2016, 08:14 PM
Last activity: Mar 17, 2018, 06:19 AM
Last activity: Mar 17, 2018, 06:19 AM