Viewing 15 posts - 286 through 300 (of 507 total)
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...
June 23, 2003 at 1:40 pm
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...
June 19, 2003 at 7:20 am
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...
June 18, 2003 at 4:28 pm
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...
June 12, 2003 at 12:24 pm
That would do it. so you added all the dependencies to one group to make sure they all fail over together?
Wes
June 11, 2003 at 9:21 am
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...
June 11, 2003 at 9:19 am
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...
June 10, 2003 at 2:37 pm
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...
June 10, 2003 at 12:44 pm
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...
May 27, 2003 at 2:40 pm
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...
May 27, 2003 at 2:36 pm
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...
May 27, 2003 at 2:16 pm
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
May 20, 2003 at 5:51 am
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
May 15, 2003 at 11:59 am
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...
May 6, 2003 at 10:46 am
May 6, 2003 at 10:41 am
Viewing 15 posts - 286 through 300 (of 507 total)