<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
SQL Server Service not starting
SQL Server Service not starting
Rate Topic
Display Mode
Topic Options
Author
Message
beejug1983
beejug1983
Posted Thursday, September 02, 2010 7:03 AM
SSC Veteran
Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 264,
Visits: 1,287
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.
Post #979492
Adiga
Adiga
Posted Saturday, September 04, 2010 10:32 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 5:05 AM
Points: 1,618,
Visits: 20,899
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
Post #980642
beejug1983
beejug1983
Posted Sunday, September 05, 2010 12:10 AM
SSC Veteran
Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 264,
Visits: 1,287
No compression on database files.
Post #980747
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, September 05, 2010 12:51 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421,
Visits: 13,734
Are there relevant entries in the SYSTEM or SECURITY Event logs?
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #980824
Joie Andrew
Joie Andrew
Posted Sunday, September 05, 2010 4:31 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 535,
Visits: 1,011
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"
Post #980857
Ramji29
Ramji29
Posted Monday, September 06, 2010 2:35 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, August 31, 2012 7:19 AM
Points: 225,
Visits: 419
Post the windows even entries and also check what Andrew pointed out.
Rohit
Post #980952
Rick.Cornell.SME
Rick.Cornell.SME
Posted Tuesday, September 07, 2010 7:47 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Saturday, March 24, 2012 3:31 PM
Points: 4,232,
Visits: 207
Like Steve mention post the relevant entries from the System, Security and Application Event logs.
Post #981582
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
