Recently one of our SQL server unable to start it. The problem with the storage LUNs.
Things you have to do: When you get this above message while starting SQL server service.
Check the event viewer both system and application log. There you will know the exact problem.
Error: SQL server failed to start the system cannot find the path specified
First check the drives and drive letters in my computer. Then verify the SQL server installed dive is available in your server.
Go to Start –> All programs –> Microsoft SQL server 2008 –> configuration tools –> SQL server configuration manager –> Right click the SQL server –> Properties –> Advanced –> Check the install path and startup parameters.
In my case I could not see the Installation drive in my server. The drives (LUN) that’s not connected properly to the server and we went to the storage side and connected the drive (LUN) and it works as expected.
Hope this would help someone.