CDW wizard fails with HasMemoryOptimizedObjects is not available


  • Hello All,

    I have a SQL 2017 CU3 server with few instances. I want to move a DB from one instance to another. Agents account are local system and they are "sysadmin" in both instances. The account that starts the job is also sysadmin.

    The error I get is:

      Event Name: OnError
     Message: Property HasMemoryOptimizedObjects is not available for Database '[TestIvaylo]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
    StackTrace:    at Microsoft.SqlServer.Management.Smo.PropertyCollection.HandleNullValue(Int32 index)
       at Microsoft.SqlServer.Management.Smo.Database.get_HasMemoryOptimizedObjects()
       at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
     Source Name: sof-dev-sql_sof-dev-sql_insuranceright_Transfer Objects Task
     Source ID: {47038FFA-0262-4CE0-9519-B404C7193373}
     Execution ID: {E20F7FFF-8125-41F0-B3B7-2BFC3ED5F23C}
     Start Time: 2/1/2018 9:09:28 AM
     End Time: 2/1/2018 9:09:28 AM
     Data Code: 0

    It used to work with SQL 2016 before I upgrade to 2017 few months ago.

    Please help

    Thanks in advance.


    • Edited by Ivaylo Valkov Thursday, February 1, 2018 7:20 AM typo
    Thursday, February 1, 2018 7:20 AM


  • Apparently it cannot move/copy DBs while online so only way is to chose detach method when copy/move in CDW.

    Problem solved.

    • Marked as answer by Ivaylo Valkov Thursday, February 1, 2018 9:18 AM
    Thursday, February 1, 2018 9:18 AM