Post reply

Database (Suspect)

  • August 8, 2006 at 7:33 am

    #62572

    One of our databases has started to become “Suspect” on a regular basis.  We have to reboot the server to correct it..

    The error message in the log is:

    2006-08-04 19:34:38.15     spid54  FCB:pen Filed. Could not open device c:\program files\Microsoft SQL Server

    udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\MFNET.mdf.

    2006-08-04 19:34:38.15     spid54  FCB:pen Filed. Could not open device c:\program files\Microsoft SQL Server\M

    FCB:pen failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\MFNET.mdf for virtual device number (VDN) 1.

    Can anybody please help.

    Many Thanks

  • August 8, 2006 at 8:15 am

    #653851

    Instead of regular reboot to fix the problem.

    Try to Restore DB with good DB Backup.

    If  this is problem with your user DB then keeping user db on primary

    drive C is not recommended. Better keep your system db on primary

    C and user db on some RAID arrangement. The risk in having all db on

    primary is, the moment primary drive C goes wrong all db are dead in water.

    Check this article by Frank McBath. For Recovery issues I found him one of the best guide. Check this link and below that I have taken excert from his link where he shows same problem in MSDB database.

    Hope this helps,

    http://www.phptr.com/articles/article.asp?p=27566&seqNum=8&rl=1

    sql server was stopped and started

    from the errorlog, we see that MSDB will not come up. A file is missing:

    2001-04-23 20:02:37.37 spid8 Starting up database 'msdb'.

    2001-04-23 20:02:37.37 spid9 Starting up database 'pubs'.

    2001-04-23 20:02:37.37 spid10 Starting up database 'Northwind'.

    2001-04-23 20:02:37.37 spid11 Starting up database 'mcbath'.

    2001-04-23 20:02:37.37 spid8 udopen: Operating system error 2(The system cannot find the file

    specified.) during the creation/opening of physical device C:\Program Files\Microsoft SQL

    Server\MSSQL;data;msdbdata.mdf.

    2001-04-23 20:02:37.59 spid8 FCB: Open failed: Could not open device C:\Program Files\Microsoft

    SQL Server/mssql/data/msdbdata.mdf for virtual device number (VDN) 1.

    2001-04-23 02:02:37.75 spid8 Device activation error. The physical file name 'C:\Program

    Files\Microsoft SQL Server\MSSQL;data;msdbdata.mdf' may be incorrect.

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • August 9, 2006 at 12:49 am

    #653984

    Many Thanks for your help.

    Ill give it a go.

    Gaynor

  • August 10, 2006 at 6:27 am

    #654279

    Another couple things you might check are antivirus software and filesystem backups.  Either of them can get the OS to report that a file doesn't exist even when it actually exists, if they are performing an operation on the file at just the wrong time.

    hth jg

     

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

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