| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | I've got 2 Arrays on my SAN.
Array 1 is 66 gb.
Array 2 is 230 gb.
I've partitioned the drives in MS2003 this way:
Array 1, Drive Q: (Quarum)...
Travis
|
06-17-2004 08:40 PM
Travis Willard | 7 | 79 |
|  | Security Best Practices tell us to remove BULITIN\Administrator from
SQL Server Logins. Is this also true in SQL Server 2000 Cluster.
Many...
John
|
06-17-2004 02:39 PM
Rand Boyd [MSFT] | 3 | 69 |
|  | We have a SQL 2000 cluster that is running on two Windows 2003 Enterprise
boxes and everything works fine, except that after the cluster has...
-DB
|
06-17-2004 01:46 PM
Rand Boyd [MSFT] | 1 | 75 |
|  | Currently, we have two sets of SQL 2000 cluster servers in two different regions. We are trying to implement log shipping for redundancy. Does log...
newby
|
06-17-2004 01:33 PM
newby | 0 | 53 |
|  | Currently, we have two sets of SQL 2000 cluster servers in two different regions. We are trying to implement log shipping for redundancy. Does log...
newby
|
06-17-2004 01:31 PM
newby | 0 | 61 |
|  | I am looking to go into a DBA role and I keep hearing
about clustering servers.
Is there anywhere I can go to learn about it? Or can
someone please...
GeorgeP
|
06-17-2004 09:20 AM
GP | 4 | 58 |
|  | Two 4GB mem clustered sql servers. Two sql instances. If
leave 1GB for the OS. 1.5GB for each instances. Still need
enable AWE?
Thanks a lot!!!
K.
Karen
|
06-16-2004 07:53 PM
Andrew J. Kelly | 5 | 53 |
|  | Hi,
We want to run a two node server cluster with Windows
Server 2003 Enterprise and SQL Server 2003 Enterprise. How
many copies of SQL Server...
Todd Harrington
|
06-16-2004 05:09 PM
Rand Boyd [MSFT] | 1 | 57 |
|  | Hello everyone!
We currently have a one node cluster (w2k3 and sql2000ent) and have had it
this way for a while waiting on the second server to...
Erik
|
06-16-2004 02:49 PM
Erik | 3 | 67 |
|  | Help:
Event Type: Error
Event Source: MSDTC Client
Event Category: Cluster
Event ID: 4389
Date: 6/16/2004
Time: 11:44:57 AM
User: N/A
Computer:... |
06-16-2004 11:51 AM | 0 | 113 |
|  | Hi,
i try to install a SQL2000 on Windows 2003 Ent.; i enable Network DTC and
manually configure a MSDTC Resource reading the article... |
06-16-2004 09:42 AM
Rand Boyd [MSFT] | 1 | 58 |
|  | Hi,
If I have an existing SQL 2000 server that I want to move into a cluster,
will I need to reinstall from scratch, or can I simply upgrade the OS...
Robert Reinstein
|
06-16-2004 09:40 AM
Rand Boyd [MSFT] | 1 | 50 |
|  | How can I install the SQL MSDE 2000(SP3a) with a instance
name on a windows 2003 cluster server.
(The MSDE config haven't to be cluster aware, I only...
GvRijssen
|
06-16-2004 04:41 AM | 2 | 64 |
|  | Hi i need to configure 2 sql2000 server (S1 e S2) in a/a mode with two
database on the first node and other two database on the second node.
I have... |
06-15-2004 09:53 AM
Rodney R. Fournier [MVP] | 5 | 63 |
|  | Hello
I have a SQL2000 64bits running on a Windows2003 64bits
cluster. SQL Version is 8.00.904.The cluster is
active/passive and has been running...
Carlos Souza
|
06-14-2004 11:36 AM
Carlos Souza | 0 | 110 |
|  | Hi,
My application is loosing some transactions fired from a trigger, this lost is because CPU usage is very high abut I cant find any log that...
Deya
|
06-14-2004 10:51 AM
Rand Boyd [MSFT] | 1 | 60 |
|  | I'm trying to setup a active/passive sql cluster for the first time.
I have node and cluster ip's and names.
Then there is this thing called the sql...
emqn
|
06-13-2004 11:59 AM
Rodney R. Fournier [MVP] | 1 | 61 |
|  | It is possible, although I would not expect the clustering technology to have a noticable impact on performance. You talk about instances. Are you...
Keith Kratochvil
|
06-11-2004 02:36 PM
Rodney R. Fournier [MVP] | 1 | 50 |
|  | I have a SQL 2K SP3 on WIN 2K ADV SP4. Please advise how to recover the master database in an active - passive cluster
I have done this before in a...
Timi
|
06-11-2004 12:52 PM
Rand Boyd [MSFT] | 1 | 58 |
|  | After a hardware failure , I'm trying to restore a SQL 2000 Cluster
Node(SP3 - Active/Active). I used HP Data Protector for my disaster...
Gianluca Pensavalle
|
06-11-2004 07:17 AM
Gianluca Pensavalle | 0 | 57 |
|  | The Physical Disk Counter does not show up in the cluster or node performance counters. I have verified that DiskPerf is supposed to install the...
BobG.
|
06-10-2004 05:26 PM
BobG. | 0 | 71 |
|  | You can also use sp_send_cdosysmail from Microsoft KB312839
http://support.microsoft.com/?id=312839
Carlos Souza
http://carlos.geekbunker.org
non...
Carlos Souza
|
06-10-2004 05:06 PM
BobG. | 1 | 64 |
|  | We are having a problem getting the security to properly authenticate
cross-server logins where the user is logged in using windows
authentication. ...
-DB
|
06-10-2004 01:59 PM
-DB | 3 | 61 |
|  | We have build 2 instances of virtual server in a SQL
cluster, namely sqlcluster1 & sqcluster2.
Service pack3 intsalled just fine in sqlcluster2 but...
Kumaresh @ GSA
|
06-09-2004 04:51 PM
Rand Boyd [MSFT] | 1 | 58 |
|  | OK, what really happens in a cluster is that both host nodes have their own
IP addresses. The Cluster service has another IP address and each...
Todd Harrington
|
06-09-2004 09:15 AM
Daan Stam | 3 | 51 |
|  | I changed the IP adressess of the heartbeat network for
my SQL 2000 (Windows 200 Cluster). Cluster is fine but
sql service will not start. Went into...
Hurting On Clustering
|
06-08-2004 01:47 PM
Hurting On Clustering | 0 | 54 |
|  | Primary keys selection and performance is the same regardless of whether you
are in a clustered environment or not.
GUIDs as PKs are not a good...
Geoff N. Hiten
|
06-08-2004 10:42 AM
Geoff N. Hiten | 0 | 68 |
|  | Hi,
I have installed Cluster Service on Windows 2000 Ad. Server and I have
done 5 tests:
1. Moving groups (failover successful)
2. Initiate...
Sas
|
06-08-2004 10:21 AM
Sas | 2 | 52 |
|  | After you have to take a node out of a SQL cluster, what is
the procedure to get it back in the cluster?
The second machine is back up and working...
Shawn
|
06-07-2004 12:59 PM
Shawn | 2 | 62 |
|  | I need to replace a node with a server that is not the same as the failed one. When the cluster was built the hardware was identical down to the...
Paul
|
06-07-2004 10:11 AM
Paul | 4 | 61 |
|  | Hi Guys,
i am using sql server 2000 on windows 2000 cluster with
150 concurrent license . now i want to add 50 more licence.
do i have to add this...
biju george
|
06-05-2004 04:04 AM
biju george | 0 | 64 |
|  | I have a Active Passive cluster on 2 DL380 compaq
prolient servers. I have installed WQuin's File screen and
Disk quota and ever since this if I move...
none
|
06-03-2004 06:00 PM
Van Thothathri | 2 | 53 |
|  | He is asking about a low-cost cluster. Using Standard Edition instead of
Enterprise.
Cheers,
Rod
"DaveK" <anonymous (AT) discussions (DOT)...
ben brugman
|
06-03-2004 09:32 AM
ben brugman | 10 | 90 |
|  | Hi All,
I'm posting it here since it seems that the way we access an SQL
server in Culster could be very similar.
I'm trying for quite a few days,...
Raul Segal
|
06-03-2004 07:59 AM
Raul Segal | 2 | 71 |
|  | How can i install the SQL MSDE (sp3a) with a instance name
on a windows 2003 cluster server.
A custumer has a windows 2003 cluster server. When i...
Gerrit van Rijssen
|
06-03-2004 02:18 AM
Gerrit van Rijssen | 2 | 65 |
|  | Hi Guys,
i am using sql server 2000 on windows 2000 cluster with
150 concurrent license . now i want to add 50 more licence.
do i have to add this...
biju george
|
06-03-2004 12:25 AM
biju george | 0 | 65 |
|  | Hi all, Firstly let me apologize if any of my questions sound stupid. I am a
newbie when it comes to SQL Server. We currently have 1 server running...
RP
|
06-02-2004 09:47 AM
Geoff N. Hiten | 8 | 64 |
|  | Hi,
we have installed sql2K on a W2003 cluster and ran into a few issues.
First one was during installation : if we would chose processor...
Hans
|
06-02-2004 09:34 AM
Rand Boyd [MSFT] | 1 | 75 |
|  | Can't read some of the log, strangeness. Have you already installed MSDTC in
the cluster?...
Rodney R. Fournier [MVP]
|
06-02-2004 08:29 AM
Sanjoy Wong | 2 | 79 |
|  | Hi,
We try to connect from a same named instance to a linked sql server in the
DMZ. The firewall has been set up to allow connections from the...
HVE
|
06-02-2004 08:18 AM
Rodney R. Fournier [MVP] | 1 | 57 |
|  | Outlook 2003 is not cluster aware.
Try xpsmtp from www.sqldev.net as an alternative.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database...
Geoff N. Hiten
|
06-01-2004 02:30 PM
Geoff N. Hiten | 0 | 59 |
|  | I am installing a new server with windows 2000 and SQL 7 i
will be restoring the databases from the old serveer to
the new but need to keep the...
Steve Wood
|
06-01-2004 09:53 AM
Andrew J. Kelly | 2 | 70 |
|  | Hi,
I have a two clusters win2k advanced server(sp3) with
sql2k(sp3) in different networks, different domains. When
I try to run a distibuted...
alexgyf1
|
05-28-2004 01:23 PM
alexgyf1 | 0 | 71 |
|  | Environment:
Windows Server 2003.
2 node Cluster single instance of SQL Server 2K sp3a.
1 SAN.
Cluster groups are:
- Cluster group with its own...
franco
|
05-28-2004 12:28 PM
Cindy Gross | 1 | 69 |
|  | I have a server that has SQL Server 2000 with SP3A with
Windows 2000 Advanced Server with an Active/Active. We
are presently not using the SQL...
Mike
|
05-28-2004 12:24 PM
Cindy Gross | 1 | 76 |
|  | For the most part setup on a Windows 2003 cluster is identical to setup on
a Windows 2000 cluster.
Things to watch out for:
SQL Server 2000 does...
Amit Kumar [MSFT]
|
05-27-2004 08:35 PM
Amit Kumar [MSFT] | 0 | 70 |
|  | Is the account you are using to run the installation a domain user who is a
local admin on both machines?
Rand
This posting is provided "as is" with...
Rand Boyd [MSFT]
|
05-27-2004 05:01 PM
Ed Lawrence | 2 | 57 |
|  | Is there an elegant way to clear out the ADO connection pool used by the SQL
Server State Service following a cluster failover?
We are using a SQL...
news.microsoft.com
|
05-27-2004 03:50 PM
bruce barker | 2 | 83 |
|  | Few questions and problems.
My config:
2x HP DL380 Servers with local c: and d:
EMC SAN providing 3 disks to me (100gig, 150gig, 4gig)
4 gig is...
Darin Seng
|
05-26-2004 08:25 PM
Darin Seng | 3 | 67 |
|  | Why would you need more than 900 bytes in an index key? Anything that large
really needs to go to full-text search instead.
--
Geoff N....
Geoff N. Hiten
|
05-26-2004 03:03 PM
Geoff N. Hiten | 2 | 66 |