Archives

Friday, October 8, 2010

SharePoint, ans Suspect SQL Database

Hi

I have a SharePoint Foundation 2010

The Share_Admin DDBB was in suspect mode.

We did:

image

image

ALTER DATABASE SharePoint_Config SET EMERGENCY
GO
ALTER DATABASE SharePoint_Config SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
DBCC CHECKDB (SharePoint_Config, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE SharePoint_Config SET MULTI_USER
GO

Now , we cand admin the SPF 2010 without problems.

Everthing goes well

Thank to Guille

(spanish links, sure there are many more in English)

http://www.guillesql.es/Articulos/Base_Datos_Sospechosa_Suspect_SQL_Server_2005.aspx

http://www.guillesql.es/Articulos/SQLServerFAQ_Base_Datos_Suspect_Sospechosa_sp_resetstatus_DBCC_DBRECOVER_Emergency_Mode.aspx

sAntos

No comments:

Post a Comment