question

MS-SQL avatar image
MS-SQL asked

MY SQL Server 2005 is not starting due to tempdb error

Hi All, SQL Server services are not starting up and giving the below error 2016-01-30 18:35:36.20 spid9s Error: 17207, Severity: 16, State: 1. 2016-01-30 18:35:36.20 spid9s FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'G:\Data\templog.ldf'. Diagnose and correct the operating system error, and retry the operation. 2016-01-30 18:35:36.20 spid9s Error: 17204, Severity: 16, State: 1. 2016-01-30 18:35:36.20 spid9s FCB::Open failed: Could not open file G:\Data\templog.ldf for file number 2. OS error: 32(error not found). 2016-01-30 18:35:36.20 spid9s Error: 5120, Severity: 16, State: 101. 2016-01-30 18:35:36.20 spid9s Unable to open the physical file "G:\Data\templog.ldf". Operating system error 32: "32(error not found)". 2016-01-30 18:35:36.21 spid9s Error: 1802, Severity: 16, State: 4. 2016-01-30 18:35:36.21 spid9s CREATE DATABASE failed. Some file names listed could not be created. Check related errors. 2016-01-30 18:35:36.21 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized. 2016-01-30 18:35:36.21 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
sql server 2005
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Check the following: 1. G:\Data\ - that this path exists 2. That there is enough free disk space on the G: drive to take tempdb at the size it's initially set to be 3. That the SQL Server service user has appropriate permissions on that directory Good luck.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

perrywhittle avatar image
perrywhittle answered
OS error 32 is a sharing violation, have you specified a tempdb location for another instance that already exists on this server. Has the instance started successfully previously, what has changed since the last restart. Please provide more information as to what has been done prior to this error appearing.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.