none
DMS online migration RRS feed

  • Question

  • I am performing a database online migration from SQL Server to Azure. I am migrating 20 databases. One of those databases received a timeout when applying the transaction log. How can I start it without interferying with the other databases which are not having any issues.

    Below is the error I received:

    Error type
    <svg class="fxs-portal-svg" height="14" viewBox="0 0 14 14" width="12" xmlns="http://www.w3.org/2000/svg">                     <g data-name="Layer 2"><g data-name="icons"><path d="M 7 14 a 6.68 6.68 0 0 1 -1.86 -0.25 a 7.28 7.28 0 0 1 -1.68 -0.7 A 6.49 6.49 0 0 1 2.05 12 A 7.55 7.55 0 0 1 1 10.54 A 6.32 6.32 0 0 1 0.25 8.87 A 7.21 7.21 0 0 1 0 7 A 6.68 6.68 0 0 1 0.25 5.14 A 7.28 7.28 0 0 1 1 3.46 A 6.49 6.49 0 0 1 2 2.05 A 7.55 7.55 0 0 1 3.46 1 A 6.32 6.32 0 0 1 5.13 0.25 A 7.21 7.21 0 0 1 7 0 A 6.68 6.68 0 0 1 8.86 0.25 a 7.28 7.28 0 0 1 1.68 0.7 A 6.49 6.49 0 0 1 12 2 A 7.55 7.55 0 0 1 13 3.46 a 6.32 6.32 0 0 1 0.71 1.67 A 7.21 7.21 0 0 1 14 7 a 6.68 6.68 0 0 1 -0.25 1.86 a 7.28 7.28 0 0 1 -0.7 1.68 A 6.49 6.49 0 0 1 12 12 A 7.55 7.55 0 0 1 10.54 13 a 6.32 6.32 0 0 1 -1.67 0.71 A 7.21 7.21 0 0 1 7 14 Z M 7 0.93 a 6.08 6.08 0 0 0 -1.61 0.22 a 6.44 6.44 0 0 0 -1.45 0.61 a 7 7 0 0 0 -1.23 1 a 6 6 0 0 0 -0.95 1.23 a 6.72 6.72 0 0 0 -0.61 1.45 A 5.79 5.79 0 0 0 0.93 7 a 6.06 6.06 0 0 0 0.22 1.6 a 6.72 6.72 0 0 0 0.61 1.46 a 6.1 6.1 0 0 0 2.18 2.18 A 6.11 6.11 0 0 0 7 13.07 a 6.06 6.06 0 0 0 1.6 -0.22 a 6.72 6.72 0 0 0 1.46 -0.61 a 6.1 6.1 0 0 0 2.18 -2.18 A 6.11 6.11 0 0 0 13.07 7 a 6.06 6.06 0 0 0 -0.22 -1.6 a 6.72 6.72 0 0 0 -0.61 -1.46 a 6.1 6.1 0 0 0 -2.18 -2.18 A 6.11 6.11 0 0 0 7 0.93 Z M 6.53 5.6 h 0.94 v 4.67 H 6.53 Z m 0 -1.87 h 0.94 v 0.94 H 6.53 Z"></path>                         </g>                     </g>                 </svg>
    Database migration error
    <label aria-hidden="true" class="azc-text-sublabel msportalfx-tooltip-overflow" data-bind="untrustedContent: $data"></label>
    Error Detail            <g data-name="Layer 2">
                            <g data-name="icons"><path d="M 7 14 a 6.68 6.68 0 0 1 -1.86 -0.25 a 7.28 7.28 0 0 1 -1.68 -0.7 A 6.49 6.49 0 0 1 2.05 12 A 7.55 7.55 0 0 1 1 10.54 A 6.32 6.32 0 0 1 0.25 8.87 A 7.21 7.21 0 0 1 0 7 A 6.68 6.68 0 0 1 0.25 5.14 A 7.28 7.28 0 0 1 1 3.46 A 6.49 6.49 0 0 1 2 2.05 A 7.55 7.55 0 0 1 3.46 1 A 6.32 6.32 0 0 1 5.13 0.25 A 7.21 7.21 0 0 1 7 0 A 6.68 6.68 0 0 1 8.86 0.25 a 7.28 7.28 0 0 1 1.68 0.7 A 6.49 6.49 0 0 1 12 2 A 7.55 7.55 0 0 1 13 3.46 a 6.32 6.32 0 0 1 0.71 1.67 A 7.21 7.21 0 0 1 14 7 a 6.68 6.68 0 0 1 -0.25 1.86 a 7.28 7.28 0 0 1 -0.7 1.68 A 6.49 6.49 0 0 1 12 12 A 7.55 7.55 0 0 1 10.54 13 a 6.32 6.32 0 0 1 -1.67 0.71 A 7.21 7.21 0 0 1 7 14 Z M 7 0.93 a 6.08 6.08 0 0 0 -1.61 0.22 a 6.44 6.44 0 0 0 -1.45 0.61 a 7 7 0 0 0 -1.23 1 a 6 6 0 0 0 -0.95 1.23 a 6.72 6.72 0 0 0 -0.61 1.45 A 5.79 5.79 0 0 0 0.93 7 a 6.06 6.06 0 0 0 0.22 1.6 a 6.72 6.72 0 0 0 0.61 1.46 a 6.1 6.1 0 0 0 2.18 2.18 A 6.11 6.11 0 0 0 7 13.07 a 6.06 6.06 0 0 0 1.6 -0.22 a 6.72 6.72 0 0 0 1.46 -0.61 a 6.1 6.1 0 0 0 2.18 -2.18 A 6.11 6.11 0 0 0 13.07 7 a 6.06 6.06 0 0 0 -0.22 -1.6 a 6.72 6.72 0 0 0 -0.61 -1.46 a 6.1 6.1 0 0 0 -2.18 -2.18 A 6.11 6.11 0 0 0 7 0.93 Z M 6.53 5.6 h 0.94 v 4.67 H 6.53 Z m 0 -1.87 h 0.94 v 0.94 H 6.53 Z">
                            </path>
                        </g>
                    </g>
    An error occured while performing ScenarioStateStorage operation. Name '[dbstate]EA_AE_Stats'
    The client could not finish the operation within specified timeout.
    The client could not finish the operation within specified timeout.

    Thursday, October 31, 2019 5:57 PM

All replies