Tuesday, 10 January 2012

I have found the error in MSSQL SERVER. Because my SharePoint site application content database is MSSQL Server not with SharePoint. I checked in Sql server here my data base is in suspect mode, So thats why this SQL server not allowing to perform any operations on that database. See here

Database can go in suspect mode for imporper shutdowns of sql server and ....etc. reasons,

To get the exact reason of a database going into suspect mode can be found using the following query.

Find the line "<customErrors mode="On" />" and change the mode from On to Off.

Now you will be able to see the error message with complete details.
You can get the error message description from Errors Event ID in Even Viewer.
And you can get all the information about error message in URL Logs in C:\...14\LOGS folder.