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!