Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2013-05-31 : 04:56:17
|
| Hi Experts,I am unable to start the SQL service on prd environment it shows the below error:FCB::Open failed: Could not open file D:\TempDB\tempdev_2.ndf for file number 4. OS error: 32(error not found).FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'D:\TempDB\tempdev_2.ndf'. Diagnose and correct the operating system error, and retry the operation.I have still 38 GB of disk space on D:\ drive. Please help its urgent Thanks,Gangadhara MSSQL Developer and DBA |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-31 : 10:07:42
|
| Is there a folder named TempDB on the D: drive? Also see the SQL Server error logs (by default they are located in Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\) and windows event log to see if they give you any additional clues. |
 |
|
|
|
|
|
Unable to start SQL server service