Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server clustering > april 2006 > threads for april 8 - 14, 2006

Filter by week: 1 2 3 4 5

SQL 2005 clustering or mirroring
Posted by Hassan at 4/13/2006 9:42:31 PM
What are organizations using today for HA ? I guess organizations who have money to spend ;) Are they using clustering or mirroring or both ? I would really like to know. Thanks ...more >>

"Stored Procedure" working every 5 minute, how?
Posted by Tark Siala at 4/13/2006 7:59:41 PM
hi i working on SQL2000, and want to make "Stored Procedure" that's working every 5 mibute, without making any calling. how i can make that ? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: ...more >>

Cluster Query plan different
Posted by traceable1 at 4/13/2006 9:32:55 AM
I have 2 SQL databases which are the same and are giving me different query plans. select s.* from hlresults h inner join specimens s on s.specimen_tk = h.specimen_tk where s.site_tk = 9 and s.location in ('ABC','WIAD') and s.date_collected between '2/1/2003' and '2/3/2006' order by s.loca...more >>

Unable to install SQL 2000 sp4 on Windows 2003 Cluster
Posted by Paul_R_UK at 4/13/2006 1:41:01 AM
I have entered the name of my virtual server, have then stated the details of the user that is a member of the administrators group on both nodes then I get the 'Setup is performing required operations on cluster nodes. This may take a few minutes' screen. 2 or 3 minutes later the setup fai...more >>

SQL Server does not exist error
Posted by Hong Wang at 4/12/2006 3:09:02 PM
Hi, I have a fail over SQL Server cluster, everything is working fine until this morning, now all the sudden, I can not open up Enterprise Manager any more. The error I get is 'SQL Server does not exist', But my client application is running fine. It seems like only SQL Server Enterprise ma...more >>

SQL BALANCED
Posted by GENNARO at 4/12/2006 12:00:00 AM
Hello Everybody, I just wanna know if is possible to balance sql 2000. I mean, my customer wants to install 2 new w2k3 balanced servers (with = WLB or CSS) , balancing Ms SQL2000 as well (read only). Do u think is possible? Thx for any help Gennaro ...more >>

Basic Disk ?
Posted by Alex Anderson at 4/11/2006 10:40:02 PM
Hello Everyone From what I've read (correct me if I'm wrong) only basic disks are supported under clustering? If this is correct, how do people with expanding arrays when space becomes a problem? Are most people using third party tools to address their space needs? I'm using HP's MSA1500...more >>

Moving SQL2000 master/msdb to SQL2005
Posted by Alex Anderson at 4/11/2006 4:24:02 PM
Hello Everyone, Can someone tell me how to move the master and msdb database from SQL 2000 to SQL 2005? I'm trying to move those databases however it's telling me there is a build conflict. How do you get around this exactly? Hopefully not a inplace upgrade. Thank you Alex Anderson ...more >>



SQL Clustering Active/Active Problem.
Posted by Cipher at 4/11/2006 2:34:15 PM
Hello to everyone, I made a new SQL (2000 SP3) Activer/Active cluster in my company with the below nodes scheme : SQLGroup1 -->SQLCLUST1 -> owner node1 SQLGroup2 -->SQLCLUST2\SQLCLUST2 -> owner node2 When i try to failover SQLGroup1 to node2 or the same procedure for ...more >>

Installing SQL Server 2000 on Cluster 2003 Pb
Posted by Enrique at 4/11/2006 1:49:20 PM
Hello, I have installed a 2 nodes cluster under W2003. I have created a group called SQL with a physical disk ressource, IP ressource (different of the IP of cluster: 192.168.0.11 for this ressource, cluster has 192.168.0.10) and Network name (sqlserv). But when I launch the SQL 2000 Enter...more >>

EVENT ID 2019 on cluster 2003
Posted by GENNARO at 4/11/2006 10:54:49 AM
Hello everybody, i got error in the EV 2019: The server was unable to allocate from the system nonpaged pool because the pool was empty. After this happened, every connections between my cluster and external clients stopped . To workaround the problem i have to manualy restart SERVER ser...more >>

SQL 2005 Cluster install Error
Posted by davesil2 at 4/11/2006 6:18:02 AM
I am attempting to install SQL 2005 as a clustered install on a single machine (we are currently testing and have no need for the true redunancy). One of the nodes in the cluster is currently running 2000 and the other is the one I'm trying to install 2005 on. Both have access to the quorum....more >>

Full-Text Indexing
Posted by mwalsh9815 NO[at]SPAM gmail.com at 4/11/2006 6:17:10 AM
Hello, I posted a question yesterday morning. I hate to ask it again, but wanted to try it once more. We have installed SQL Server 2000 Enterprise edition into a clustered environment. There are two nodes, SQL is clustered and working properly. When we installed it we chose to not install t...more >>

SQL2005 Clustering Under Virtual Server Release 2
Posted by Tom Frost at 4/10/2006 12:55:02 PM
I've set up a 2 node virtual server R2 running Win 2003 enterprise server with Svc Pack 1 on each node and have also installed Microsoft clustering. All shared drives failover thru cluster administrator fine. I have just completed jinstalling a named instance of SQL2000 with clustering on the...more >>

stopping services in SQL 2000 failover cluster
Posted by Fred at 4/8/2006 12:00:00 AM
Hi, I have a SQL 2000 failover cluster. I want to stop all SQL services on the active node, but not fail it over to the passive node. How can I accomplish this? I see that I should use cluster admin to stop services, but not 100% sure how. Can you provide me with a step-by-step guide. Should I...more >>


DevelopmentNow Blog