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.
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.
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.