MSSQLSERVER_2527
New: 14 April 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.0 |
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. |
Explanation
This informational message indicates that the specified 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. To be available, all files within the filegroup must be online. The filegroup that is offline may be for the large binary object (LOB) data, for the row-overflow data, or for the data itself. If there are no other problems, all other indexes for the same table are checked.
User Action
- View the state of the files by querying either the sys.database_files or sys.master_files catalog view.
- Restore the offline file from a current backup.
- Re-run the DBCC statement.
See Also
Other Resources
sys.database_files (Transact-SQL)
sys.master_files (Transact-SQL)
RESTORE (Transact-SQL)