Category Archives: Connectivty

Customer getting the error message (Error Message 512)when tried to open the SQL Managed instance database properties from SSMS client? This error message due to multiple database_guid for the same database_name in themsdb_backupset you can avoid this error message by deleting the database backuphistory as follow. msdb.sp_delete_database_backuphistory @database_name=database_name msdb.sp_delete_database_backuphistory @database_name=db physical id

https://azure.microsoft.com/en-us/blog/connections-and-sql-azure/ If we dont perform any action (idle session without any active request)on the Azure SQL DB session it will throw the time out error message after 30 minutes.