| title | MSSQLSERVER_2527 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 04/04/2017 | |
| ms.prod | sql | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | language-reference | |
| helpviewer_keywords |
|
|
| ms.assetid | 1cef90ef-9c39-44e6-bc7f-316c8f53c10c | |
| author | MashaMSFT | |
| ms.author | mathoma |
[!INCLUDE SQL Server]
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 2527 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | DBCC_INDEX_FILEGROUP_IS_OFFLINE |
| Message Text | Unable to process index I_NAME of table O_NAME because filegroup F_NAME is offline. |
This informational message indicates that the index cannot be checked because one of the filegroups that stores data for the index is offline. The state of the files in a filegroup determines the availability of the whole filegroup. For a filegroup to be available, all files within the filegroup must be online. If there are no other problems, all other indexes of the same object will be checked.
To view the state of the files for the specified filegroup, query either the sys.database_files or sys.master_files catalog view.
Restore the offline file from a backup.
sys.database_files (Transact-SQL)
sys.master_files (Transact-SQL)
RESTORE (Transact-SQL)