Forum Replies Created

Viewing 15 posts - 286 through 300 (of 508 total)

  • RE: Replacing SAN on SQL 2000 Cluster

    last time I checked it was seperate.

    Wes

  • RE: Service Pack 3a on Cluster Environment

    We have had many many problems with service packs and clusters. We manually apply the service pack to each node. There is a known issue with service packs files don't...

  • RE: Replacing SAN on SQL 2000 Cluster

    How did you plan on moving the data? You would ether have to restore from backup or have the ability to copy the data to the new SAN. If it...

  • RE: Replacing SAN on SQL 2000 Cluster

    You should be able to detach the databases copy them over to the new san and attach them to your new cluster. I've done several non cluster to cluster moves...

  • RE: Timeout expired

    Can you pull server versions MDAC version and service pack levels? It may not be the machine have you had your network guys take a look at thier end? Can...

  • RE: Clustering Question

    That would do it. so you added all the dependencies to one group to make sure they all fail over together?

    Wes

  • RE: Timeout expired

    I would look at a profiler dump to see what is going on. There are several scripts that can capture profiler traces based on an error here. It could be...

  • RE: Clustering Question

    Shouldn't it have failed over sql when you failed the active node period? I thought that the ip was tied to the sql server so if a top level resource...

  • RE: Feedback Appreciated Re my Standards Doc

    Programming Standards

    2. “Reads” that are performed only to verify the existence of at least one row should either use an exact key or use the “count” option. (This standard was...

  • RE: Clustering: Node removed from cluster

    I would check all the sql and cluster services and make sure the password is good. Did the node get evicted from the cluster group or does it show as...

  • RE: MSDE - Bench Mark

    Without knowing the application I don't know if there will be an issue. I would run perfmon from the start and keep an eye on it. If this is a...

  • RE: MSDE - Bench Mark

    There are other issues as well, how many concurrent users will try to reach this server? win2k pro only supports like 10 connections I think. There may be other limits...

  • RE: Registry key changing in cluster environment

    See Q308766 Verify your server registry:

    HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetlib\Tcp TcpPort:

    REG_SZ:1433

    Take a look at that technet article and see if it helps.

    Wes

  • RE: partitioned views with Standard Edition

    Thanks for the reply, I look forward to your production runs to see how it really handles load with a true production data. Keep us informed.

    Wes

  • RE: partitioned views with Standard Edition

    Well, to be honest with you I'm not sure. If you run the query and look at the execution plan what does it say vs. the estimated plan? Does it...

Viewing 15 posts - 286 through 300 (of 508 total)