Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Can't start MSSQLSERVER service. Can't find file specified


Can't start MSSQLSERVER service. Can't find file specified

Author
Message
hayden_jones
hayden_jones
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 257
SQL 2008 R2. Windows Server 2008 R2.
VMWARE
Needed much more space on the drive SQL was installed on (E: drive).
OS guys said, "we can't add that much space. We'll add another big drive and you can copy the files an we'll rename the drives"
I said ok. The copy was done by Netbackup. All files seem to be in place.
Rename was done. Now all E: drive files are back on E: and it's much bigger. Happy, right?

I try to start the MSSQLSERVER service and got

Windows could not start the SQL Server (MSSQLSERVER) service on Local Computer.
Error 2: The system cannot find the file specified.

No mention of the file it was looking for. Nothing in event log (app, security, or system). Nothing in SQL log.
Where can I look?

Would appreciate an answer today. This is only QA, but the business wants to use it and are unhappy.
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
Has the account that the SQL Server Service runs under been given the necessary permissions on the 'new' E: drive?

Regards
Lempster
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36070 Visits: 18736
In addition to the question above, have you checked the "errorlog" in the /log folder under SQL Server? That will likely clue you into which files are not available.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
hayden_jones
hayden_jones
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 257
The Storage Team (who did the drive copy) said all drive and folder permissions would be copied.
I just checked and the local administrators group has full control to the drive and all folders.
The service id is in the administrators group. If the name of the file in question is logged somewher
that would give a hint. I can't find a log that has that.
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
If it's a default installation then you should find the SQL Server error log under E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log
hayden_jones
hayden_jones
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 257
SQL Server Error logs have no new entries for today. The service did not start. Event logs have nothing
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36070 Visits: 18736
Did you sqlservr.exe get moved? There should be something in error logs or the Event logs that an attempt was even made.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
hayden_jones
hayden_jones
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 257
Brother Jones,
Good catch.
It is not there. There are 2 files missing from the binn folder. I haven't scoped out what the other one is.
But I am reluctant to just put it there. I have to find out why it didn't copy and how many other files didn't copy.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8780 Visits: 16554
hayden_jones (2/21/2014)
SQL 2008 R2. Windows Server 2008 R2.
VMWARE
Needed much more space on the drive SQL was installed on (E: drive).
OS guys said, "we can't add that much space. We'll add another big drive and you can copy the files an we'll rename the drives"

This is real easy to do, cant understand why they made you go through the process of recreating the drive contents.

  • open VM properties and select the existing disk

  • type a new larger value for the virtual disk and close and save the VM properties

  • in the VM guest OS, start DISKPART from a cmd prompt

  • type LIST DISK and identify the disk number that has had size increased

  • type SELECT DISK disknumber

  • type LIST VOLUME and identify the volume number you wish to extend

  • type SELECT VOLUME volumenumber

  • type EXTEND

  • exit cmd prompt

  • et voila, your volume has been resized!






hayden_jones (2/21/2014)
I said ok. The copy was done by Netbackup. All files seem to be in place.
Rename was done. Now all E: drive files are back on E: and it's much bigger. Happy, right?

I try to start the MSSQLSERVER service and got

Windows could not start the SQL Server (MSSQLSERVER) service on Local Computer.
Error 2: The system cannot find the file specified.

No mention of the file it was looking for. Nothing in event log (app, security, or system). Nothing in SQL log.
Where can I look?

Would appreciate an answer today. This is only QA, but the business wants to use it and are unhappy.

Clear the event logs and then try starting sql again, there should be an indication of the file it cant locate

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
hayden_jones
hayden_jones
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 257
Out of 1,996 files copied, there were 3 missing files. They were all .exe files.
Many other .exe files were, in fact, copied. Two of them were the SQLAGENT.EXE and sqlservr.exe.

The services were down at the time, but I'm thinking that somehow there was a handle on these
and that that was the reason they were not copied. I should have thought, though, that the
Netbackup job copying the drive should have reported the failure to copy these. I'll have to ask
the Storage guys about that.

Anyhow, the 3 files were manually copied and all is well.

Thanks, Steve
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search