all groups > sql server clustering > february 2005 > threads for february 22 - 28, 2005
Filter by week: 1 2 3 4
Newbie MSDTC question
Posted by Lapchien at 2/28/2005 9:37:59 PM
What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster?
Cluster is already setup and virtual sql instance running ok...
Thanks
... more >>
memory usage
Posted by Calvin Do at 2/28/2005 4:41:02 PM
Hello,
I have a sql 2000 box that has roughly 15 datbases. How do i determine how
much memory/cpu a particular db is using?
thanks!
Calvin
... more >>
Instance wil not come online
Posted by Hans de Bruin at 2/28/2005 4:00:02 PM
2 out of 4 instances on my 3 node cluster wil not come online on one off
the clusternodes, unless I add an alias (which I removed after
installing sp3). The application eventlog complains about not being able
to connect to the instance. I can connect to the instance remotely, but
apparently ... more >>
Microsoft OLE DB Provider for SQL Server"
Posted by Yianni at 2/28/2005 1:19:02 PM
I receive a "Cannot generate SSPI context" error message when you try to
connect to a SQL Server 2000 SP3 server computer.
According microsoft's article ID 843248 there is a hot fix. I do not want to
install SP2 just the hot fix.
Does anybody know the actual ID name of the hotfix. I am tr... more >>
Two named instances. Why ?
Posted by Rubens Luque Sanches Junior at 2/25/2005 8:24:02 PM
What is the better to use in active/active SQL 2000 cluster ?
1 Default instance and 1 named instance
or 2 Named Instances ?
There are any advantages or disadvantages ?
thanks a lot !
Rubens
... more >>
Having fun with moint points
Posted by Hans de Bruin at 2/25/2005 4:13:41 PM
To keep the number of driveletters to a minimum, have
the same directory structure on the instances and do
something with disks and performance I tried this:
MSSQL$I1\Data
\Data1 <- mount point
\Tlog
\Backup
\Backup1 <- mount point
MSSQL$I2\Data
\D... more >>
Want to Call DTS Package....
Posted by Patrick at 2/25/2005 1:48:22 PM
Hi All
I want to call DTS Package from Job. How, can I do that ?
First DTS Package transfers data and then it calculates on that imported
data.
Wating for reply
Silent Ocean
... more >>
VBScript to Enumerate Cluster info
Posted by news.cox.net at 2/24/2005 8:06:26 PM
Does anyone know how to enumerate cluster info (Microsoft cluster server
2000) through VBS. But more specifically, is there a way to execute the MOVE
GROUP function from within VBS/VBScript.
Thanks,
JFR
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDTC question
Posted by Calvin Do at 2/24/2005 12:57:14 PM
Hello,
may be a dumb question, but how do i determine if i've setup msdtc correctly
on a sql 2000 cluster?
thank you
Calvin
... more >>
EXIT CODE 51- SEtup failed to perform the required operation on t
Posted by Anand Musunur at 2/24/2005 12:49:03 AM
I am trying to install a named instance on an active/passive cluster using
sql 2000 and windows 2003 both entrprised editions.
HEre is the latest sqlstp.log which says it failed/.
01:45:22 Begin Setup
01:45:22 8.00.194
01:45:22 Mode = Normal
01:45:22 ModeType = NORMAL
01:45:22 GetDefinition... more >>
Change from Active\Active to Active\Passive Cluster
Posted by Joe K. at 2/23/2005 6:47:05 AM
I have a SQL Server 2000 Cluster with Windows 2000 Server.
The Cluster was set up as a Active\Active and I would like to change it to
Active\Passive.
What do I need to change go from Active\Active to Active\Passive?
Thanks,... more >>
Maximize memory usage on active-active sql cluster
Posted by ettore.pancini NO[at]SPAM gmail.com at 2/23/2005 2:02:25 AM
we have an active-active sql cluster configured as follow:
server A - 4gb ram - sql server instance #1
server B - 4gb ram - sql server instance #2
currently each sql instance is configured to use at most 2gb of ram.
in case of failover, both instances switch on one server, effectively
usinge ... more >>
SQL Cluster in Windows 2003
Posted by j05e at 2/23/2005 1:21:02 AM
Hello:
I have installed SQL 2000 Enterprise in a Microsoft Cluster Windows 2000
several times. I am trying now to install it on a MSCS Windows 2003 and I can
see there are several differences. First of all, when I did with Windows 2000
the first step was to configure the Microsoft Distribu... more >>
SQL Clustering Options
Posted by TABMCSE at 2/22/2005 7:03:02 PM
I have read that SQL Server with MSCS supports an Active/Active setup
via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can
anyone shed light on this? Any support documentation that would help would be
great! Thank you.... more >>
Using SQL Mail in a cluster
Posted by Calvin Do at 2/22/2005 3:46:41 PM
Hello,
I'm trying to set up alerts for jobs and backups, using sql mail. Will this
work in a clustered enviroment? if so, can you please forward some
information on how to get this set up?
thanks in advace.
Calvin
... more >>
CLUSTER NAME
Posted by Aju at 2/22/2005 1:03:43 PM
Hi ,
is there any command to display current cluster name through query .
Thanks
ARR
... more >>
Passwords for cluster and servers
Posted by Dave at 2/22/2005 6:58:29 AM
I have a 2 node cluster running Win2000 enterprise and MS clustering.
Also SQL server. Would there be a problem using the same domain
password for SQL and for the clustering service? I thought I read
that there may be a problem but I don't recall where it read it.
Thanks for any help.
... more >>
|