No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

OceanStor BCManager 6.5.0 eReplication User Guide 02

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
What Can I Do If the Storage Information Used by the Protected Group Topology Is Not Updated After Data or Log Files Are Deleted from an SQL Server Database and Protected Groups Are Refreshed

What Can I Do If the Storage Information Used by the Protected Group Topology Is Not Updated After Data or Log Files Are Deleted from an SQL Server Database and Protected Groups Are Refreshed

Symptom

After data or log files are deleted from an SQL Server database, protected groups are refreshed successfully in the background. However, the information about the storage system where the deleted files reside is still displayed in the protected group topology.

Possible Causes

After data or a log file is deleted from the SQL Server database, the file status displayed on the system configuration information list of the database is offline. As a result, the system misjudges that the file is not deleted.

Procedure

  1. Use SQL Server enterprise manager to log in to the SQL Server database.
  2. Enter the SELECT * FROM xxx.sys.database_files (xxx indicates the database name) SQL statement or check the sys.database_files table of database xxx 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 status 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.
Translation
Download
Updated: 2019-05-21

Document ID: EDOC1100075861

Views: 10771

Downloads: 55

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next