SQL Managed Instance DB Property

JoelP 241 Reputation points
2023-07-11T02:12:04.92+00:00

HI,

I started getting below issue when viewing database property in SQL Management studio. I tried purging the backups, it will work for a while, then will get the same issue after a few minutes. Database is working fine..

User's image

User's image

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Rahul Randive 6,936 Reputation points Microsoft Employee
    2023-07-11T02:37:32.59+00:00

    Hi @JoelP

    Please find detailed explanation and possible mitigation of this issue in below blog.

    https://techcommunity.microsoft.com/t5/azure-database-support-blog/subquery-returned-more-than-1-value-when-open-azure-managed/ba-p/3712422

    Hope this helps!

    Please don't forget to upvote and Accept as answer if the reply is helpful

    If this answer helped you, please mark it as "Verified" so other users can reference it.

    Thank you.


0 additional answers

Sort by: Most helpful