Jun 21, 2012

Jun 19, 2012

Versions of SharePoint

Ø  Microsoft Content Management Server (CMS) (Year 2002)
Ø  SharePoint Portal Server (Year 2003)
Ø  Windows SharePoint Services 3.0 (Year 2003) – Free Ware
Ø  Microsoft Office Share Point Server (MOSS) (Year 2007) (Built on .NET 2.0) –    
   Combination of CMS and SharePoint Portal Server
Ø  SharePoint Foundation Server (Year 2010) – Free Ware
Ø  Microsoft SharePoint Server (Year 2010)

Jun 13, 2012

Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database.

Problem:
I got this error when I tried to stop and start the Windows SharePoint Services Search service by the following:
Central Administration ->Operations ->Services on server->Windows SharePoint Services Search->Stop
Central Administration->Operations->Services on server->Windows SharePoint Services Search->Start
The below is the step by step solution to fix this issue.
Solution:
1. We have to delete some log files of database in the SQL Server by following the path:
Stop the SQL Server Express Service: Start -> All Programs -> Administrative Tools -> Services -> SQL Server -> Right click Stop
2. Now delete the following file in the below locations:
WINDIR%\SYSMSI\SSEE\MSSL.2005\MSSQL\DATA\WSS_Search_ Servername.mdf
WINDIR%\SYSMSI\SSEE\MSSL.2005\MSSQL\DATA\WSS_Search_ Servername_log.LDF
Or in this path WINDIR%\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
3. Restart the SQL Server Express Service by following the path:
 Start -> All Programs -> Administrative Tools -> Services -> SQL Server -> Right click Start
4. Now restart the Windows SharePoint Services Search by following the path:
Restart the Windows SharePoint Services Search: Central Administration->Operations->Services on server->Windows SharePoint Services Search->Start
5. In the Configure Windows SharePoint Services Search Service Settings page, in the Search DB section, give a new DB name in the Database Name field. Click Start.
6. If you give the old DB name you will get the error. Hence try giving the new DB name.
Please free to comment and share this post if it helps you!