You Have Refreshed Protected Groups After Deleting Data or Log Files in SQL Server Database, but Storage Information About the Protected Groups Is Not Refreshed in the Topology

1.Use SQL Server enterprise manager to log in to the SQL Server Database.
2.Enter the SELECT * FROM [errorDB].[sys].[database_files] (errorDB indicates the database name) SQL statement or check the sys.database_files table of database errorDB in the enterprise manager to check whether the state_desc field of a file is OFFLINE.




If the state_desc field of a file is OFFLINE, contact database engineers to restore the file to ONLINE.
If the database file has been deleted, contact database engineers to delete the file.

3.After database engineers resolve the problem, refresh protected groups and check whether the topology is correct.

Scroll to top