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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply