SQL Server Services are not able to start

Question

Hi Team,

SQL Server services are not able start 

Event Log Error:

FCB::Open failed: Could not open file L:\Program Files\Microsoft SQL Server\MSSQL10_50.xxx\MSSQL\Data\templog.ldf for file number 2.  OS error: 2(The system cannot find the file specified.).

Kindly suggest us.

---

subu

Answer 1

TempDB log and data files are recreated everytime the instance is re started. It appears like somehow the folder got deleted. If so, Please recreate the folder, you do not need to create any file inside it, just make sure you have the path " L:\Program Files\Microsoft SQL Server\MSSQL10_50.xxx\MSSQL\Data" and sql server service account can access it...

Now, start the SQL service, tempdb will create its log there automatically....

---

Hope it Helps!!

Answer 2

Hi Team,

Due to memory utilization 100% at that time using -f option one of my Engineer will we re-started the services.

How can we put into back again please suggest us.

Thanks in advance.

---

subu

Answer 3

you can go to the start up parameters and remove "-f" parameter and restart the sql server..  To go to Start up Parameters--> go to Configuration Manager-->right click on the sql server service and go to ---> Properties and you should see Start up parameters tab.. use caution while doing this..

---

Hope it Helps!!

Answer 4

Hi

I did as per your suggestion i got below Error:

Error 3(The system cannot find the path specified.) occurred while opening file 'master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

---

subu

Answer 5

did you remove just '-f'? looks like you removed more stuff, you need to remove just the switch '-f'..please use caution while doing this....

are you on sql 2008R2??

After removing the "-f" switch in the startup parameters, you should have the following in the  field,

-dE:\DATA\master.mdf;-eE:\MSSQL10_50.SQL2008R2\MSSQL\Log\ERRORLOG;-lE:\DATA\mastlog.ldf

where the file paths should be the path your master mdf and ldf files and Errorlog. if your are missing these, please where these files areon your computer and give the correct path and restart the service,...it will work... switches -d,-E and -l should be there, just replace the filepath with yours...

---

Hope it Helps!!

Answer 6

Hi Subu

Stan already suggested the correct method but if you are still not clear, please refer explainition with screenshots SQL Server Service is not starting .

---

Thanks
Saurabh Sinha http://saurabhsinhainblogs.blogspot.in/
Please click the Mark as answer button and vote as helpful if this reply solves your problem