September 2, 2010 at 7:03 am
SQL Server 2005 service is not starting, I checked the ErrorLog file and found the below error :
"2010-09-02 18:03:40.60 Server Error: 3411, Severity: 21, State: 1.
2010-09-02 18:03:40.60 Server Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall."
I tried to rebuild the master database by using following command :
"start /wait D:\setup.exe /qn INSTANCENAME=mssqm$ICT REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword"
This command ran successfully without any notification then I tried to start the SQL Server in single user mode by using -m; parameter but when I start the SQL Service it gives an error i.e. :
"Windows could not start the SQL Server on local computer. For more information review the system even log. If this is a non microsoft service, contact the service vendor and prefer to specific error code 3411 "
When I checked the event log it shows :
"The SQL Server (SQLFORMIRROR) service terminated with service-specific error 3411 (0xD53)."
I tried many ways but could not succeeded plz help.
September 4, 2010 at 10:32 am
Check if the database files are compressed. If yes remove the Compression option in the Operating System. Refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 5, 2010 at 12:10 am
No compression on database files.
September 5, 2010 at 12:51 pm
Are there relevant entries in the SYSTEM or SECURITY Event logs?
September 5, 2010 at 4:31 pm
Is the syntax of the command to reinstall master correct? I ask because you listed
"start /wait D:\setup.exe /qn INSTANCENAME=mssqm$ICT REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword"
supplying an instance name of mssqm$ICT yet your error is
"The SQL Server (SQLFORMIRROR) service terminated with service-specific error 3411 (0xD53)."
indicating your instance name with problems is SQLFORMIRROR.
Joie Andrew
"Since 1982"
September 6, 2010 at 2:35 am
Post the windows even entries and also check what Andrew pointed out.
Rohit
September 7, 2010 at 7:47 am
Like Steve mention post the relevant entries from the System, Security and Application Event logs.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply