The SQL Server (MSSQLSERVER) service terminated with service-specific error 3414 (0xD56)

atifnaeemmalik
atifnaeemmalik used Ask the Experts™
on
My SQL Server 2005 suddenly stop working by failing the services of sql server and sql agent to start. In event viewer, i am getting the following

For SQL Server Service
------------------------------
The SQL Server (MSSQLSERVER) service terminated with service-specific error 3414 (0xD56).

For SQL Agent Service
-----------------------------
The SQL Server Agent (MSSQLSERVER) service depends on the SQL Server (MSSQLSERVER) service which failed to start because of the following error:
The service has returned a service-specific error code

Kindly Help me.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
please check the contents of the ERRORLOG file in the sql server installation folder /LOGS ...
QPR

Commented:
does the account specified to start the service have the permissions to do so?
has the account been locked out?

Author

Commented:
I have checked the folder /LOGS and model.ldf was curropt. replaced the file and started the service. all fine again.
thanks for help
QPR

Commented:
out of interest, what was the msg in the log for this?
Calvin DayEngineer, Programmer

Commented:
Documented here, for the benefit of those that may encounter Error Event 3414 in the future.
{
In anticipation of potential hard drive failure, of a production mechanical hard drive that has been in continuous service for 5-6 years. It was decided to replace it with a Solid Stated Hard Drive.

On the bench we rebooted the existing drive to confirm that it was healthy before imaging it.

As luck would have it Windows 2003 Enterprise SP2, started up to an un-scheduled three stage Check Disk, which damaged some SQL system databases, preventing SQL 2005 from starting. Of course we have loads of backups; however, restoring backups is rather hard to do when SQL will not run.

Of course rebuilding the server is an option, although painful. In our environment we are also running SQL 2005 Report Services. Now if you have ever migrated or restored a SSRS server you know this is prohibitive and in some case un-reliable, with encryption keys and a litany of goofy MS constructs.

Now then, following “Guy Hengel [angelIII / a3]’s” comments in this EE thread, by interrogating the SSQL “ERRORLOG” file. By doing so, we were able to determine that “Model.mdf” was the damaged file. Knowing that unlike other system databases “Model.mdf” is not closely tied to the specific SQL install and having another healthy backup SQL Server install. We;
1)      Stopped the SQL service on the backup computer.
2)      Copied the “Model.mdf & Model.ldf” files to the damaged SQL computer.
3)      Rebooted the damaged SQL computer, and it WORKED!!!!
}
Saved my life and a ton of time.

Just thought it was worth writing up!

All the best,

Greg

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial