Error message 512

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

Published by Santhosh Reddy

I am working as a SQL Server DBA.

Leave a comment