all groups > sql server clustering > january 2004 > threads for january 22 - 28, 2004
Filter by week: 1 2 3 4 5
Re-apply Service Pack after new node is installed?
Posted by P. Carignan at 1/28/2004 1:30:22 PM
I had to build a new node to replace a crashed node in my
SQL cluster.
After installing MSCS & SQL, I can transfer my resources
from one node to the other.
But, SQL has some problems.
Looking at the files, I see SQLSERVR.EXE to be a different
version on each servers.
Do I need to... more >>
Problems with restore and backup database sql 2000 on W3K
Posted by hmendez at 1/28/2004 9:36:06 AM
Hello,
I have sql 2K on cluster Windows 3K but when i do a backup report this message on eventlo
Event Type: Erro
Event Source: MSSQLSERVE
Event Category: (2
Event ID: 1705
Date: 1/26/200
Time: 9:21:33 A
User: N/
Computer: JUPITE
Description
18204
BackupDiskFile::OpenMedia: Backup ... more >>
Client connectivity
Posted by Kirit Randeria at 1/27/2004 11:31:35 PM
How to set the idle timeout for the idle client
connection ?
... more >>
Problem adding "Physical Disk" Resources to Groups
Posted by Michael [multnomah] at 1/27/2004 11:00:41 PM
We have a Windows 2003 EE Cluster Node [QAT2] that has an
attached NAS device via iSCSI for disk storage.
Previously, we had two large NAS partitions, drives K:
[DATA] and L: [LOG]. Then we decided that we wanted to
have 3 Virtual Servers, so we split up the partitions into
6 drives [3 DATA a... more >>
Node1 no longer sees MS SQL Server
Posted by scottf at 1/27/2004 6:46:44 PM
I recently upgraded our server to a 2 node cluster. We
installed MS SQL server, and created the virtual server
necessary for the cluster failover to work. I noticed
today that I can not use SQL Enterprise manager from
Node1. It does not see the instance of SQL Server. Under
Server Groups i... more >>
SQL Cluster and update Jet 4.0 to SP8
Posted by Chris at 1/27/2004 1:04:16 PM
Request for info on updating only Jet 4.0 to SP8 on a SQL
2000 sp3 cluster. Does each node need to be done
separately or does in recognize that it is in a clustered
environment.... more >>
missing drives
Posted by Mirna at 1/27/2004 11:06:13 AM
The servers are W2003 Enterprise
SQL is 2000 Ent sp3a
Active/Passive
I just finished configuring the cluster and it looks fine
except SQl does not see all drives. In other words when
trying to create the database in enterprise manager
server does sees only one drive. It bahaves the same w... more >>
IP Address used for xp_cmdshell?
Posted by Kevin at 1/26/2004 4:17:50 PM
I have SQL Server 2000 with SP3 running on a windows 2003
cluster. I need to setup log-shipping from a SQL Server 7
database server. The 2 servers are separated by a
firewall. The guy that configures the firewall doesn't
want to do trial-and-error to figure out which IPs to open
up. I ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Looking for a Win2003 Cluster/SQL 2000 Whitepaper
Posted by Michael Bates at 1/26/2004 11:57:55 AM
I am having a hard time finding any details/caveats with
installing SQL 2000 on a Windows 2003 cluster.
Can anybody point me in the right direction?
Thanks!
Michael Bates... more >>
Setup Failed
Posted by Fred Jean at 1/26/2004 11:15:38 AM
Hi,
I'm trying to install a second instance of SQL Server on a
clustered node, from Node B. I had to cancel the first
execution of setup installation program for different
reasons. After that, we haven't been able to delete /Binn
directory of that instance on Node B (sharing access
vio... more >>
More than 1 SQL instance in a node?
Posted by Benny Koh at 1/25/2004 8:56:05 PM
My boss tells me to install 2 SQL instances on each node. This means 8 instances on 4 nodes.
His reasons: a) Rather than 1 instance with databases having both high and low transactions, better to split into 2 instances, 1 with high usage databases, and the other with lower usage databases. CPU and... more >>
Different SQL Server Service packs in the cluster?
Posted by Carlos Gonzalez - Phoenix, AZ at 1/23/2004 2:31:04 PM
Can a virtual SQL Server 2000 SP2 and a virtual SQL Server 2000 SP3a coexist in the same Windows 2000 Datacenter cluster? Will the different versions of MDAC coexist in each node?... more >>
ADO Connection Problem with Port in Network Address
Posted by Sue at 1/23/2004 12:11:41 PM
We just installed a new SQL Server 2000 Active/Active
cluster. We are trying to connect to the database from VB
using ADO using the connection string:
Provider=sqloledb;Data Source=HAZXXXXX\SDXXX;Network
Library=dbmssocn;Network Address=172.99.99.99,1433;Initial
Catalog=<DatabaseName>;Us... more >>
email notification from the clustered SQL Servers
Posted by Cata at 1/23/2004 11:18:43 AM
Hi,
I am new with the SQL Server clustering, what do you
recommend for jobs notification?... more >>
Setup failed to perform required operations on the cluster nodes.
Posted by John Marks at 1/23/2004 10:39:17 AM
Thannks in advance for an help on this.
I am attempting to set up SQL2K EE on Win2003 cluster
(active/passive).
I get this error msg "Setup failed to perform required
operations on the cluster nodes." during the install
process. I have looked through the newsgroups and
knowledge base... more >>
Add a node problem
Posted by Paul Dube at 1/22/2004 2:14:04 PM
I have a problem with my SQL cluster. One Windows 2000 server had a
disk crash recently so I decided to reinstall it all under Windows
2003. So now I have the new Windows 2003 server and the good old
Windows 2000 server.
Let's call my servers SQL1 (Windows 2003) and SQL2 (Windows 2000).
I i... more >>
Failover doesn't work properly whith network problems.
Posted by Chris Carmichael at 1/22/2004 11:56:05 AM
Hello All,
We have a SQL cluster in active/passive configuration. Unfortunately, our
network has been having issues. More specifically, the line protocol on the
Cisco 3550 that the primary node on this cluster is connected to seems to
drop off temporarily from time to time.
So the problem ... more >>
Log Files on a Cluster Resource
Posted by Greg Boyle at 1/22/2004 9:39:24 AM
I have the following configuration
2 IBM x335
1 FASTT200 HA
1 Disk Array RAID 10 - 1 Partition (Drive S:)
1 Disk Array Raid 1 - 2 Partitions (Drives Q: & L:)
The q: Drive and l: drive being 1 physical cluster
resource, the sql server will NOT let me place the SQL
Logs on the L: Driv... more >>
|