If somebody like the post and its helpful in your work then, add comments.

Wednesday, August 25, 2010

SharePoint Database when set to status ‘Suspect’

Hi,

Today my SharePoint 2010 Admin database automatically set to status Suspect.

SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454(Suspect)

I search for that issue and I got the solution which is below

EXEC sp_resetstatus 'SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454'

ALTER DATABASE [SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454] SET EMERGENCY

DBCC checkdb('SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454')

ALTER DATABASE [SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [SharePoint_AdminContent_c92d3a99-1800-4cac-b986-7e380ea42454] SET MULTI_USER

No comments:

Post a Comment