Are there any issues if Major DB operations like table truncation, big amount of data delete or Shrink are performed on AWS SQL Server 2014 SE with Multi-AZ switched on? Should the Multi-AZ switched off before Major DB operations?

  • All operations worked fine with Multi-AZ enabled. However, shrink stalled (suspended) because of the long running queries. I could not proceed with Shrink, even though I tried to shrink and release 1 GB at a time. – user2431585 Aug 6 at 2:08

Your Answer

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

Browse other questions tagged or ask your own question.