Post reply

unable to start the sql service

  • May 31, 2013 at 2:57 am

    #278119

    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

  • May 31, 2013 at 3:02 am

    #1619983

    Error 32 is "File in use by another process." Find out what other process that is and stop it from using your TempDB files.

    https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply