all groups > sql server clustering > september 2004 > threads for september 8 - 14, 2004
Filter by week: 1 2 3 4 5
MSCS & SQL
Posted by OldDogNewTricks at 9/14/2004 5:33:45 PM
This is my first cluster setup. I have two identical
servers, a RAID array, Wondows 2000 Server Advanced and
SQL Enterprise. All new hardware and on the HCL. I create
a MS failover cluster, then install the SQL Cluster. I now
have (2) physical servers and (2) virtual servers, each
complete... more >>
About Upgrade RAM on SQL 2000 Cluster
Posted by at 9/14/2004 12:11:27 PM
Hi all,
i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster A/P
on both node. There is any problem with the cluster service or SQL to do it
?
May i do it first on the passive node , swith istance on the passive (now
active) node and upgrade the passive node (previous a... more >>
Can anyone recommend the best resource for performance tuning a SQL cluster?
Posted by Adam Freden at 9/14/2004 9:43:24 AM
I have a couple clusters (each with eight processors total, and 16 GB RAM
total), but am not getting the performance desired. I "inherited" these, I
didn't build them. Can anyone recommend any resources on tuning the cluster
and tuning the SQL service for the best performance?
... more >>
Upgrade SQL2000 default instance to clustered instance
Posted by uffe_67 NO[at]SPAM yahoo.com at 9/13/2004 2:35:43 AM
I am attempting to upgrade SQL2000 enterprise edition on Win 2000 advance to a
clustered default instance. I run SQL setup as per the books on-line
instructions but on the Existing Installation screen, the option to
"Upgrade your existing installation to a clustered installation" is
greyed out.
... more >>
Cluster on Same Box (for educational/training purposes)
Posted by Erik Grob (MCP) at 9/12/2004 8:28:25 PM
Is it possible to setup a second instance of SQL Server Enterprise on a box
and setup clustering? I have someone asking me that has only one Server to
do this with and they want to learn about Clustering.
Win2003 <-> Win2003 (SameBox)
OR
Can you run SQL Server on an XP machine and still... more >>
MS DTC Resource won't start
Posted by Jezza at 9/12/2004 7:09:02 PM
I've just installed clustering on a pair of Intel Itanium boxes running 64
bit Server 2003 Enterprise. I've followed the setup instructions in 301600
and 817064 for MS DTC. The disk, ip address and network name resouces come
online ok, but the MSDTC resource fails with the following event log ... more >>
SQL Cluster recovery from node failure
Posted by gotdough at 9/12/2004 1:57:05 AM
Cluster services gives the high availability needed - that is great. But I
have never seen any discussion about what happens when a node fails - what do
you do to get everything back to the active-passive tandem.
I imagine there is not much difference in terms of recovery procedure for
eit... more >>
SQL Mail on a Virtual Cluster
Posted by anonymous at 9/10/2004 12:55:34 PM
SQL Mail is not cluster aware on a failover, but having
it is better than not, I believe. What tasks can be
scheduled to check for the proper functioning of SQL Mail
on a cluster . Are there any third party tools that can
help in doing this?... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Clustering concepts...
Posted by Karl Albrecht at 9/9/2004 10:47:10 AM
We have just setup two servers running a copy of SQL 2000 on Windows 2000
server. Each of these servers is running vendor software that interrracts
with the databases. One server is primary and one is backup. Clients only
interract with the vendor process on the servers and not the SQL directly.
... more >>
Multi-Istance or clustering , which is the best solution ???
Posted by opianeta at 9/8/2004 1:59:53 PM
Hi,
I have a big doubt about...
We have near 20 dbs with many applications that work with.
During the days there are many problems about coesistence, because
some applications are very CPU and disk expensive.
nevertheless the are some applications that require failover architecture so
we u... more >>
Cluster access using IP
Posted by Nik at 9/8/2004 1:44:44 PM
I joined a company as a DBA
the company has cluster servers set up.
I was given the 3 ip addresses. i for the cluster and 2 for for the ones the
cluster is made up of. and my login is set up to use SQL Server
Authentication.
How do i connect to the server. I do not know if they are active/act... more >>
Log shipping with clustering
Posted by barbara_2003 NO[at]SPAM hotmail.com at 9/8/2004 12:46:17 PM
We would like to implement 2 node active-passive clustering coupled
with log shipping. Clustering is for high availability and log
shipping for DR purpose. Do we have any white papers for this kind of
setup? Is it possible to host the log shiiping secondary database on
the inactive cluster serve... more >>
|