all groups > sql server clustering > march 2005 > threads for march 15 - 21, 2005
Filter by week: 1 2 3 4 5
Rename Default Instance
Posted by Rubens Luque Sanches Jr. at 3/21/2005 9:31:40 PM
Hi,
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
... more >>
changing sql server service account password
Posted by bill at 3/21/2005 4:07:31 PM
SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
services use.
When I change the password for this account in active directory, I also
changed the password for the services in the Services properties... more >>
Database conference ...
Posted by Bill at 3/21/2005 1:48:17 PM
All,
I was looking for a database centric developer conference.
Any suggestions please ?
Thanks in advance.
Bill
... more >>
Recently Rebuilt SQL2K Cluster
Posted by Justin Hoffmann at 3/21/2005 11:29:04 AM
I have recently had to rebuild my SQL Server 2000 sp3a 2 node active/passive
cluster running on Windows 2000 AS SP4. We ran into issues about two weeks
ago after a SAN migration (I'll spare all the gory details). When my
previous cluster died, I used one of the nodes as a stand alone instanc... more >>
Distributed databases
Posted by Reshma Prabhu at 3/19/2005 12:50:05 PM
Hello,
I am new to distributed databases. I wanted to use stored
procedures in distributed databases.
If a view contains query in which tables from different servers are used,
how should I reference them. For example
Suppose me view is
CREATE VIEW dbo.Example1
AS
SELECT... more >>
SQL Server job failure - When node fail over
Posted by Siva Prasad [SIVA] at 3/19/2005 10:53:02 AM
I have a setup of SQL Server 2000 Active \ Passive Cluster on Windows 2003
Environment. Maintenance plans were created when the Node-1 was active.
Two weeks back the SQL Server cluster service failed over to Node-2, where
in all other services are remain in the Node-1.
But the backup jobs ... more >>
Virtual servers not visible
Posted by Jon at 3/18/2005 2:47:05 PM
Hi,
I a a two node win 2003 cluster running active / active with serveral SQL
2000 virtual servers between them. I have noticed the following and am
wondering if this is correct behaviour and if not how I correct it:
1) If I start up enterprise manager and go to register one of the Virtu... more >>
SQL Cluster and IPSEC
Posted by Arnie Rowland at 3/17/2005 11:01:07 PM
Anyone here with hands on experience with SQL Clustering and using IPSEC?
Perhaps we could exchange information...
-Arnie Rowland
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server Clustering failover problem.
Posted by Carlos at 3/16/2005 7:25:02 PM
Hi all,
I have a SQL Server cluster running which one database server machine is
active and one database server machine is standby.
But once I tried to test the failover, I have found that both database
server will claim it as active. Which the case is one database server will
operate a... more >>
change license mode on SQL 2k cluster
Posted by afsinclair NO[at]SPAM optonline.net at 3/16/2005 12:14:30 PM
I need to change the SQL server license mode on an installed SQL server
2000 cluster from processor license to per seat.
Does anyonw know?
... more >>
Antivirus experiences
Posted by Christian Castro at 3/16/2005 7:45:04 AM
I would like to know the group's experiences on that topic. I had several
issues in the past but antiviruses had changed a lot and maybe you have
good/bad experiences to share that I can apply to a clustered
SQL2000sp3/w2003 install i'm doing now. Hopefully you can include AV brand
and versi... more >>
SQL cluster backup strategy
Posted by Shawn Winters at 3/15/2005 5:12:03 PM
We're in the process of designing a 2 node sql cluster for a client. I want
to know the best way to backup/restore the cluster using Veritas Backup Exec
9.1 or 10.0. I've installed the remote agent to the cluster with no
problem. I'm using a dedicated management pc that is not a node in the... more >>
Miniature Clustering Lab
Posted by A. Robinson at 3/15/2005 12:19:04 PM
I'm looknig to set up a miniature clustering lab at home and looking for some
advice.
I would like to hopefully keep the price tag to around $750-$1250.
I've already found a couple of boxes that I'm going to use for my nodes
(dual node cluster). I can do all the internal stuff myself (NI... more >>
Clustered Replication - Whose IP is It
Posted by rum63 at 3/15/2005 7:01:00 AM
I have a data warehouse transactional replication environment in which
we have muliple Publisher/Distributors(100+) and a single subscriber.
All Publishers and subscribers are SQL 2000.
We recently converted the subscriber box to a Win2003
Cluster.(Publishers are Win2K for the most part, there... more >>
|