From the docs, it would seem that restoring a full database backup file is possible, but can one also restore transaction logs?

(the idea is to minimize downtime in a migration from on-prem to MI).



No, log shipping to Managed Instance is not possible; it only supports the restore of full backups. See this thread:

And the limited syntax diagram for RESTORE in the documentation for Managed Instance:

The docs imply that RESTORE ... FROM URL will implicitly add WITH RECOVERY and so there will be no opportunity for logs to be applied after the initial restore. So your downtime will be >= the time it takes to take a COPY_ONLY full backup, put it somewhere MI can access, restore it, and re-point your app(s). You might also want to read through this tutorial, for a different approach.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.