SharePoint Content Database in Suspect Mode

If you are getting this error message while accessing SharePoint

"Cannot connect to the configuration database"

There can be several reasons for this and some of them are described here with possible solutions
http://support.microsoft.com/kb/823287

but another reason is that when your database goes to suspect mode you will get the same error.

What Does Suspect Mode Means?

There are different reasons for database to go in suspect mode like error in its physical files e.g:- log file.

It is difficult to make database online when made as suspect database. There are several ways we can identify that a database is in suspect mode.


I used the following commands to bring my database online



exec sp_resetstatus DBNAME

ALTER DATABASE DBNAME SET EMERGENCY
GO

ALTER DATABASE DBNAME SET SINGLE_USER
GO


DBCC CheckDB (DBNAME , REPAIR_ALLOW_DATA_LOSS)
GO

ALTER DAtabase DBNAME SET MULTI_USER
GO



examples of these command with DBNAme is


exec sp_resetstatus 'SharePoint_Config_703e926e-d84f-4ab1-941e-308e85137400'
ALTER DATABASE [SharePoint_Config_703e926e-d84f-4ab1-941e-308e85137400] SET EMERGENCY
GO
ALTER DATABASE [SharePoint_Config_703e926e-d84f-4ab1-941e-308e85137400] SET SINGLE_USER
GO
DBCC CheckDB ([SharePoint_Config_703e926e-d84f-4ab1-941e-308e85137400] , REPAIR_ALLOW_DATA_LOSS)
GO

ALTER DAtabase [SharePoint_Config_703e926e-d84f-4ab1-941e-308e85137400] SET MULTI_USER
GO

Error on Webpart Page

I have seen many information workers and sharepoint developers struggling with this basic issue in which they created a custom webpart/or used an OOB webpart.... added it to a webpart page....if there are some errors/issues in webpart .....NOW when they open the page they can't see the contents of that page , neither they can edit the page from ribbon because they are getting an error message on page due to error in webpart.....


a very simple solution to this problem is to add a query string parameter

?contents=1 at the end of page ......this will open the page in a mode where you will be able to remove items from your page

so lets say URL of your webpart page was

http://servername/pages/abc.aspx

you should type

http://servername/pages/abc.aspx?contents=1

Virtual Event - Office 15/SP 2013 Installation and Preview

In SharePoint world, everybody is talking about SP 2013 and Office 15 products these days, Microsoft has made it easy for users to experience the product features by first time providing

SharePoint Online and On campus installation option together but many of users, especially who are relatively new to SharePoint are not familiar with Online option, some are facing issues in installation of version on local VMs.

Let’s look at these options and issues together in a live session and Fix them

• SP 2013 online V/S Offline
• Set up your account for installation on Office 365/SharePoint Online and Product Preview
• Software Requirement of Standalone Installation
• Hardware Requirements of Standalone Installation
• Installation issues of SP 2013 standalone
• How to fix the installation issues

Join me on Live Meeting for a session on Installation and Configuration of SharePoint 2013 CP , Office 15 CP Products and High level preview.

Venue: Live Meeting (Send me an email at khalil.urrehman@gmail.com ) to book a slot [Limited to 15 users, first come first serve]
Date & Time: Saturday, 19th August, 2012 2 PM Pakistan Standard Time (GMT+5)