Cannot Detach/Attach SSAS Database to move to Another Server
-
We have a new server and want to move the SSAS databases from the old server to the new one. I thought this could be done by detaching the db on the old server, copy db files to new server, and then attach db on new server. However, when I try to detach I get the following error:
The ‘Attach/Detach functionality’ feature is not included in the ’64 Bit Standard’ edition of Analysis Services
I've reviewed a few ohther sources with people having similar problem. Most said this is only available with Enterprsie edition. We are using SQL Server 2012 Standard.
Couple questions:
1) Is this true? Can you not detach/attach with standard?
2) If you can detach/attach with standard, how can I do this?
3) If you cannot, how do you suggest moving the databases?
-
ptownbro (12/10/2016)
We have a new server and want to move the SSAS databases from the old server to the new one. I thought this could be done by detaching the db on the old server, copy db files to new server, and then attach db on new server. However, when I try to detach I get the following error:The ‘Attach/Detach functionality’ feature is not included in the ’64 Bit Standard’ edition of Analysis Services
I've reviewed a few ohther sources with people having similar problem. Most said this is only available with Enterprsie edition. We are using SQL Server 2012 Standard.
Couple questions:
1) Is this true? Can you not detach/attach with standard?
2) If you can detach/attach with standard, how can I do this?
3) If you cannot, how do you suggest moving the databases?
Question, why not simply backup-restore-drop old?
-
Um. Only because I didn't know you could =) Thanks. That seemed to work. Also saw you could deploy to another server as well from Visual Studio.
Thanks!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply