Beyond web logs

If you face this error in SharePoint 2010 “Invalid index. (Exception from HRESULT: 0x80070585)” – this means that indexing needs to be correct for the view of the list to work.

To solve, please follow these steps:

1. Modify view of your list as shown in below screen shot:

2. Uncheck “Last Updated” field

3. Index problem should be resolved with this.

4. Now, repeat step 2 and check “Last Updated” field again.

Hope this helps!

Sharepoint

In order to restore SharePoint Configuration Database from Suspect Status back to the normal, please following following steps:

EXEC sp_resetstatus 'SharePoint_Config'

ALTER DATABASE SharePoint_Config SET EMERGENCY

DBCC checkdb('SharePoint_Config')

ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('SharePoint_Config', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE SharePoint_Config SET MULTI_USER

Hope this helps!

Sharepoint