Unable to start SQL Server service-error 3414

After the emergency shutdown of the computer the SQL Server (SQLEXPRESS) service does not start and gives an error message:

Failed to start SQL Server (SQLEXPRESS) on local computer. Details are contained in the system event log.... error code 3414

SQL Server Error 3414 occurs during log-in/start-up time while recovery process for SQL Database is not completed successfully. You can check the description of this error in event log or error log. It occurs when SQL Sever find difficult to recuperate scheduled database from suspicious situation. Go through the following link to resolve the issue:

To restore the Project Server database, you can use the restore feature of Microsoft SQL Server. To do this, follow these steps:

  1. Click Start, click AllPrograms, click Microsoft SQL Server, and then click SQL Server Management Studio.
  2. In the Connect to Server dialog, the Server Type should be "Database Engine". Check the Server name and Authentication and make changes if needed, then click the Connect button.
  3. Expand SQL Server if needed and then expand Databases.
  4. Right-click the database, point to All Tasks, and then click Restore then click Database….
  5. From the list of backups, click the backup to restore, and then click OK to start the restore.
  6. Click OK to confirm that the restore completed successfully.

or you can try to use paid service