Workaround for SQL (MSSQLSERVER) service startup error code 3414

Environment Introduction:

(Window server R2 + SQL server R2)

Our company has a managed to eliminate the server, in line with the principle of saving use, in the company to find a place to configure, as an internal server; Run an internal small CRM, convenient for everyone to use. The company work every day early nine to six, but most of the time sales staff go late, so set up the server 10 o'clock automatic shutdown, morning who early to the boot.

Problem found:

Before a period of time quite normal, nothing wrong, also less attention; This morning sales told CRM can't open, I opened the system to see.

1, think the site downtime, first restart IISReset, no;

2, check the database service, did not start, try to start, unexpectedly appear 3414 error;

Did not recruit to find Niang help, found this article http://www.jb51.net/article/81571.htm, through his operation, magical solved, again special record.

My workaround is to:

(SQL database version consistent, inconsistent not tried)

1, from the installation of SQL and the normal operation of the computer to copy a file, find the installation path of the database, for example, my installation path is: C:\Program Files\Microsoft SQL Server\mssql.1\mssql\data, Copy Model.mdf and Modellog.ldf;

2. Put the copied files in the wrong computer's installation path (same as above), replace the original problem files can be.

Summary:

SQL Server is an essential part of our development project, so it is important to master his skill in operation. There is a problem, do not rush to solve, to analyze what has been done after the error caused by, this can not only avoid the occurrence of similar errors, but also to our solution to bring great convenience.

Workaround for SQL (MSSQLSERVER) service startup error code 3414