Post reply

FCB::Open failed: Could not open device

  • May 13, 2005 at 1:05 am

    #88995

    Database gone into suspect status with the following error.

    These below errors received from SQL Server Error Log.

    Starting up database 'DBName'.

    udopen: Operating system error 32(error not found) during the creation/opening of physical device E:\Microsoft SQL Server\MSSQL\Data\DBName.mdf.

    FCB:pen failed: Could not open device E:\Microsoft SQL Server\MSSQL\Data\DBName.mdf for virtual device number (VDN) 1.

     

    How to bring the database online?

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • May 13, 2005 at 1:08 am

    #558612

    I found that the above errors were related to case where in SQL Server trying to bring the database online at that time some of the database files

    namely *.mdf or *.ldf being used by other process like Virus Scan or Backup by TSM Agent.

    I detach the database and attache it. it resolved the issue.

     

     

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • May 13, 2005 at 9:09 am

    #558747

    Thanks for the followup and you might want to read Brian Kelley's article on SQL Server and Anti Virus to prevent this type of thing: http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritydealingwithantivirusprograms.asp

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

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