Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Can't start MSSQLSERVER service. Can't find file specified Expand / Collapse
Author
Message
Posted Friday, February 21, 2014 8:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 8:03 AM
Points: 46, Visits: 238
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.
Post #1544029
Posted Friday, February 21, 2014 8:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:18 AM
Points: 2,048, Visits: 1,403
Has the account that the SQL Server Service runs under been given the necessary permissions on the 'new' E: drive?

Regards
Lempster
Post #1544039
Posted Friday, February 21, 2014 8:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:00 PM
Points: 33,204, Visits: 15,354
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
Post #1544042
Posted Friday, February 21, 2014 8:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 8:03 AM
Points: 46, Visits: 238
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.
Post #1544044
Posted Friday, February 21, 2014 8:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:18 AM
Points: 2,048, Visits: 1,403
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
Post #1544046
Posted Friday, February 21, 2014 8:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 8:03 AM
Points: 46, Visits: 238
SQL Server Error logs have no new entries for today. The service did not start. Event logs have nothing
Post #1544063
Posted Friday, February 21, 2014 8:59 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:00 PM
Points: 33,204, Visits: 15,354
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
Post #1544068
Posted Friday, February 21, 2014 9:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 8:03 AM
Points: 46, Visits: 238
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.
Post #1544092
Posted Friday, February 21, 2014 10:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 6,306, Visits: 13,605
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"
Post #1544114
Posted Friday, February 21, 2014 10:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 8:03 AM
Points: 46, Visits: 238
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


Post #1544123
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse