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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|