| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | OK, here is the scenario.
We have bought some nice new servers to replace our 3 year old ones. Also,
we are migrating to Win2K3. Managed to upgrade...
Freddy
|
05-26-2004 05:35 AM
Freddy  | 4 | 68 |
| | | You can have the node ready to join the cluster but it must actually be in
the cluster before SQL can install to it. Once the node is in the...
Geoff N. Hiten
|
05-25-2004 03:41 AM
Beverley | 1 | 68 |
| | | You have a preferred owners list on the properties page of the resource
group. The host nodes are listed in preferred order. The actual...
Geoff N. Hiten
|
05-24-2004 06:41 PM
Thanks | 1 | 62 |
| | | How do yo install the analysis services with a clustered
64-bit database? the documnet 308023 has instructions as
to the procedure but none of the...
John Gazdacka
|
05-24-2004 04:55 PM
John Gazdacka | 0 | 69 |
 | | Hi!
I have two-node cluster on Windows 2000 Adv Server sp4. There are two
instanses of MS SQL 2000 Server sp3, one on each node. I have...
Roust_m
|
05-24-2004 02:54 AM
Roustam Akhmetov | 4 | 180 |
| | | You are assuming that you are running into this problem in the article. You
may be running into something entirely different. You even stated that...
Geoff N. Hiten
|
05-22-2004 09:46 AM
Darren Summers | 6 | 89 |
| | | I have a 2-node cluster working properly and have setup a pipe name
alias for the virtual server instance (as per KB article Q815431).
When I start...
snOOp
|
05-22-2004 06:11 AM
Thomas De Rousse | 13 | 108 |
| | | Hello,
after installation of SQL Server instance in the Cluster,
the SQL Server Agent and Full Text resources were deleted
in Cluster Administrator....
Frederic
|
05-21-2004 11:50 AM
Frederic | 0 | 79 |
| | | Here's an odd one; I was changing the password on a 2-node
failover cluster (via enterprise manager, of course) when
it asked to restart SQL Server...
F
|
05-21-2004 11:21 AM
Francis Apel | 2 | 53 |
| | | Again, the answer is "It Depends". You can use EE Server based with either
device or user CALs. EE allows multiple instances on a single host with...
Robert
|
05-21-2004 10:57 AM
Geoff N. Hiten | 4 | 60 |
| | | Comments Inline
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association...
Geoff N. Hiten
|
05-21-2004 10:26 AM
Geoff N. Hiten | 0 | 60 |
| | | Hi all,
We have 3 server, compaq 570ML and try to find out the way to increase
availability and fault tolarency with MS SQL 2k server, W2k AS. I...
Dan
|
05-21-2004 10:03 AM
Rand Boyd [MSFT] | 2 | 62 |
| | | This corresponds to the Microsoft Article 819546.
On a clustered instance of SQL Server 2000, data storage
on mounted drives is not supported.
This...
Dan
|
05-21-2004 09:44 AM
Geoff N. Hiten | 1 | 65 |
| | | Hi,
I want to test the clustering environment before implementing the same on
production servers. The resources i have with me are high end ( p4 2G...
DBA76
|
05-20-2004 06:16 PM
Stephen Strong | 4 | 67 |
| | | I have a SQL Server 2000 Enterprise Edition on a Windows
2000 Advanced Server. This cluster is set up as
Active/Active. Periodically the SQL Server...
Mike
|
05-20-2004 04:55 PM
BB | 1 | 58 |
| | | Our failover has worked before, but this time the sql
server agent cannot start. Any suggestions at all about
where to start looking?
Beth
|
05-20-2004 02:08 PM
Rand Boyd [MSFT] | 1 | 72 |
| | | Our goal is to monitor the event when our Active/passive cluster fails over
to the second node, indicating a problem on the primary node.
We are...
Tom Celica
|
05-20-2004 09:40 AM
John Toner [MVP] | 1 | 79 |
| | | Hi,
Where does the msdtc.log file need to be located on a Win2K setup with SQL7
?
hdjim69
|
05-20-2004 08:14 AM
Clive Challinor [MSFT] | 1 | 59 |
| | | I have a concern with a clustered SQL server pair which had a failed node recently replaced with a new server. I am understanding that when I...
Ken Krause
|
05-19-2004 02:44 PM
Geoff N. Hiten | 3 | 64 |
| | | At the bottom of KB article 827449 there is a link to KB
article 812666 which is exactly what is needed to recover
the Full text search option in a...
Dude
|
05-19-2004 12:28 PM
Dude | 5 | 122 |
| | | Hi
what is the recommended way of applying a service pack in a 2-node active-passive cluster
Regards
Fred
Fred
|
05-19-2004 11:55 AM
Ken Krause | 4 | 65 |
| | | Hi,
Is it possible for both nodes in a SQL Server 2000 cluster
to open up the same .MDF & .LDF file on the shared array
simultaneously and still be...
Benoit
|
05-19-2004 05:21 AM
Microsoft | 4 | 62 |
| | | We can't get SQL 2000 to load on the new node (successfully added to the cluster). We are using the procedure How to add nodes to an existing...
Pat Hall
|
05-18-2004 05:21 PM
Pat Hall | 11 | 96 |
| | | Hi, If I have two machine in a cluste
- if I install SQL on one will the installation replicate on the other or do I have to install both seperatly
-...
Steve
|
05-18-2004 12:30 PM
Jason Buffington | 3 | 55 |
| | | I thought of opening a new thread, so it does not get overlooked..
So my problem is that I can't install sp3a on a virtual SQL 2000 server,...
suzana ciur
|
05-18-2004 12:25 PM
Jason Buffington | 1 | 81 |
| | | Does any one have any experience with MS Clusters and
GeoCluster from NSI?
Also, does any one have any experience of installing sp3
for SQL Server on...
suzana_C
|
05-18-2004 12:25 PM
Jason Buffington | 3 | 90 |
| | | Are there any issues or downtime when running ComClust.exe
on a cluster after SQL 2K has been installed? Thanks, John
jlee
|
05-18-2004 09:38 AM
Rand Boyd [MSFT] | 1 | 128 |
| | | SQL Named Instances are always accessed via \. You "may" be able to do something clever with a DNS PTR record but I've not tried it. I'm also not...
Stephen Strong
|
05-17-2004 02:46 PM
Geoff N. Hiten | 3 | 71 |
| | | Can some point to a doc (cookbook) for building a 3 node sql2000 cluster on
win 2003.
thanks,
JR
jr
|
05-17-2004 01:56 PM
Stephen Dybing [MSFT] | 3 | 59 |
| | | Hi,
we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003
2-node Cluster. The Installation breaks, and in the sqlstp.log we find...
F. Neumann
|
05-17-2004 12:34 PM
Rand Boyd [MSFT] | 3 | 214 |
| | | Is this even the right forum to ask?
How do you start figuring the processor capacity needed for an SQL
Sever when there isn't much relevant...
William Lipp
|
05-16-2004 10:44 PM
William Lipp | 0 | 59 |
| | | Possible, Yes.
Recommended, No.
FYI, you can't just pick two machines at random and create a cluster.
First, the machines must be on the Cluster...
Geoff N. Hiten
|
05-14-2004 03:41 PM
Ken Krause | 3 | 76 |
| | | Yes it is possible, but you would have to have enough resources to run all
the applications. BTW, I think you don't quite understand...
Geoff N. Hiten
|
05-13-2004 08:26 PM
Geoff N. Hiten | 0 | 64 |
| | | Is there anyone doing this? If so I have a few questions. I installed Volume Manager(Configured my volumes) and then Cluster Service in Microsoft. ...
Lontae Jones
|
05-13-2004 04:06 PM
Lontae Jones | 0 | 64 |
| | | Hi all
I'm in the starting phase on planning a cluster enviorment. I'm really a newbie at clustering. I have one question that I will be very glad...
Fredrik
|
05-13-2004 10:35 AM
Geoff N. Hiten | 1 | 57 |
| | | Hi,
Can I implement logshipping in Clustering sql server?thank you
Li
|
05-13-2004 05:19 AM
Luca Bianchi | 1 | 67 |
| | | I meet problem when one node of cluster servers go down.
The backup node take the shared disk and IP , network
name, ..., but can not bring the sql...
David Liu
|
05-12-2004 02:12 PM
Cindy Gross | 1 | 55 |
| | | Hi
final question for now! I have installed an active passive 2 node cluster and it works fine. What things should I look out for which don't behave...
Fred
|
05-12-2004 02:06 PM
Cindy Gross | 2 | 68 |
| | | My question is, How much is going to effect?is the performance degraded to
80%...?If I use raid 10,is going to solve this problem, thank you for...
Li
|
05-12-2004 12:13 PM
Geoff N. Hiten | 3 | 63 |
| | | We have problem on our 2 original sql instances in a 4-node cluster.
Both the 2 old instances get one warning and one error message in the
event...
Peter Lindberg
|
05-12-2004 05:09 AM
Peter Lindberg | 2 | 85 |
| | | Here is a great starting place for your...
Rodney R. Fournier [MVP]
|
05-11-2004 10:39 AM
Rodney R. Fournier [MVP] | 0 | 66 |
| | | Environment:
Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
Problem:
I end up in error 17883.
I am aware that the solution...
franco
|
05-11-2004 09:38 AM
franco | 2 | 108 |
| | | Has anyone had difficulty with UDF's in a clustered environment? We have
some DTS code that references a user defined function. When we run the...
Rob Heyman
|
05-11-2004 08:51 AM
Farooq Mahmud [MS] | 1 | 57 |
| | | I am having an issue using linked servers on
active/active cluster. I have two instances, and when
both instances are on the same machine, things...
anonymous
|
05-11-2004 08:47 AM
Farooq Mahmud [MS] | 1 | 50 |
| | | I have installed a dual node active passive W2K3 Clusters with SQL 2K.
The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs.
How...
Lord Melch
|
05-10-2004 05:09 PM
Rand Boyd [MSFT] | 2 | 68 |
| | | Hi
what is the standard way of getting notified on failover
TIA
Fred
Fred
|
05-10-2004 03:33 PM
John Toner [MVP] | 3 | 65 |
| | | Looking for some advice on an issued that just popped up. Not sure if
this was the cause but after applying MS04-011 and 012 MSDTC will not
run on...
Derek Leach
|
05-10-2004 10:35 AM
Derek Leach | 2 | 76 |
| | | I am running a sql server 2000 cluster on a windows server 2003
machine. Every time I try to install MSDTC it fails and this is what
is in the Event...
jf@uk.com
|
05-08-2004 12:14 PM
Lord Melch | 1 | 80 |
| | | Given tempdb is recreated on startup is there any reason it must reside on a shared cluster resource
After installation to the shared resource...
spee
|
05-07-2004 02:55 PM
Rand Boyd [MSFT] | 1 | 75 |
| | | What is the right procedure to start an instance of a clustered Active/Active Sql Server
The online-book unspecifically writes
From a command...
Moglia Michele
|
05-07-2004 04:06 AM
Michele Moglia | 2 | 69 |
