Post reply

Error messages

  • February 23, 2007 at 12:32 am

    #67989

    I have a cluster sql server 2000. The eventlog of the primary node has the following messages

    "LogWriter: Operating system error 21(The device is not ready.) encountered.

    fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

    udopen: Operating system error 21(The device is not ready.) during the creation/opening of physical device s:\sql\database\MSSQL\data\msdbdata.mdf.

    FCB:pen failed: Could not open device s:\sql\database\MSSQL\data\msdbdata.mdf for virtual device number (VDN) 1."

    in the sql server error logs there is no messages for this period. It was restrated.for a period of some 5 minutes there are no messages in the error log but the eventlogs has these messages.

    What does this means..Did a device failed during the startup??

    What does FCB means??

    Everything is running fine now but I want to know what all these messages mean and is there something wrong??/

     

     

  • February 23, 2007 at 12:59 am

    #691333

    I'd guess that maybe the dependecies are not properly ordered or grouped. I'd take this to mean that sql was up before the drives, in cluster resource sql should depend upon all the drives being up before it comes up. ( that's my best guess, anyway - )

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 23, 2007 at 3:22 am

    #691346

    how do I properly arrange or order the dependancies.

  • February 23, 2007 at 3:43 am

    #691349

    Arun

    Double-click on the SQL Server resource in Cluster Administrator and go the Dependencies tab.  Add as a dependency every disk resource on which SQL Server data or log files reside.

    John

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

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