Post reply

Problem with SQL Server 2005 cluster

  • September 5, 2008 at 4:01 am

    #124406

    Hi everyone,

    I have a big problem.

    I have active\active SQL Server 2005 cluster.

    It's based on Eva 8000 storage.

    The problem is thant the cluster resources randomly move to another node of cluster.

    How can I identify this problem?

  • September 5, 2008 at 5:54 am

    #867680

    - Have you checked (several) logfiles? (Windows log, SQL log, SAN log)

    - What configuration changes did happen before these problems arised?

    Wilfred
    The best things in life are the simple things

  • September 5, 2008 at 5:57 am

    #867684

    Do you mean they failover to the other server? Have a look in the cluster.log, the event viewer and the sql server errorlog. These should show when and why they moved.

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

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