Post reply

Suspect databases

  • February 14, 2004 at 2:20 am

    #161621

    How to access and fix suspect database if data and log files are present for that database?

    --sntiwary

  • February 14, 2004 at 3:01 am

    #494079

    check the error log to determine the cause.

    sp_resetstatus 'dbname'

  • February 14, 2004 at 9:59 am

    #494092

    This is the error :

     

    17052 : Device activation error. The physical file name 'D:\MSSQL\Data\store_Data.MDF' may be incorrect.

    17204 : FCB:pen failed: Could not open device D:\MSSQL\Data\store_Data.MDF for virtual device number (VDN) 1.

    17207 : udopen: Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device D:\MSSQL\Data\store_Data.MDF.

     

     

    I ran sp_resetstatus 'dbname' but still the status is suspect.

     

    --sntiwary

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

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