all groups > sql server clustering > november 2004 > threads for november 22 - 28, 2004
Filter by week: 1 2 3 4 5
How to run my Curser more faster?
Posted by raj at 11/28/2004 4:15:03 PM
I have a stored procedure written for number of updates, inserts to the
database. This stored procedure takes too long to run. I have created few
indexes around few tables, but the response time is not that defferent.
THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and
... more >>
How to FTP via VPN to sites with real adresses on different IP's ?
Posted by Jason Robertson at 11/25/2004 5:39:56 PM
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites u... more >>
SAN drive config for SQL Cluster
Posted by Randy at 11/25/2004 12:27:02 PM
What's the best physical drive configuration for a SQL cluster on a SAN?
Would creating a large (14drive/2buses) physcial RAID 1+0 array with
appropriate sized LUNs be acceptable for the quorum, tempdb, ms-dtc, and sql
tlog shared resources?
Or would individual mirrored drives defined as L... more >>
SQL server 2000 will not install on Windows Server 2003 cluster
Posted by SqlJunkies User at 11/25/2004 10:46:02 AM
please help on this error
i was installing SQL Server 2000 ENT on Windows Server 2003. Cluster. after assignin the VirtualServer Ip the Setup stoped and generated an event in the event viewer." Event ID:1000, Faulting Application_INS5576._MP, version 5.53.168.0, faulting module sqlsui.dll, ve... more >>
Active/Active Clustering - W2K - Adding More Instances
Posted by Mike NO[at]SPAM Synergy at 11/25/2004 9:59:05 AM
We currently have two W2K Enterprise servers running MSCS and each of these
is running MS SQL2000 enterprise.
The Cluster is Active/Active and we have a single instance of SQL running on
each server.
The question I have is would it be possible to add another Instance of SQL
on both Boxes... more >>
Is Active / Active possible with 2 SQL machines and a SCSI array??
Posted by PeterD at 11/23/2004 10:03:01 AM
I have 2 DELL Windows 2003 Enterprise server machines with SQL 2000
Enterprise Edition and 1 PowerVault 220S SCSI Array set in Cluster mode
hooked up to both of these machines.
I want to know is it possible to use this configuration with SQL in a ACTIVE
/ ACTIVE state.
By Active/Active, ... more >>
Distributed transaction with clustering server
Posted by Yuval Peleg at 11/23/2004 8:03:30 AM
I can't perform a distributed transaction between a remote
server to the central server.
I have 3 sql server 2000 enterprise edition. 2 of them are
installed on win2K server (LOCAL1, LOCAL2) and the other
(CENTRAL_SQL) is installed on clustering win2K server.
None of them is in domain.
... more >>
Cluster does not restart SQL group after network failure
Posted by Dan at 11/22/2004 3:57:04 PM
All,
We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an
active/passive configuration using 2 nodes. During the course of testing it
we had a general network failure in which the network was unavailable. The
virtual SQL and Windows IP address resources went down a... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|