|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Replacing Shared Storage on a two node cluster Posted by Asim Mian at 4/30/2004 10:01:54 AM I have a two node SQL Server 2000 cluster running on
Windows 2000 Advanced Server. It's an Active/Passive
configuration. Now we will be replacing the shared
storage system from a Dell PowerVault 220 to EMC Clarion.
Is there anyway to accomplish this without rebuilding the
whole cluster (We...more >>
SQL multi instance cluster questions Posted by Hassan at 4/30/2004 9:25:14 AM I have a couple of questions now that I installed a multi instance SQL 2K
failover cluster on Win2003 . In my case 2 instances
1) How does one apply SQL service packs or Windows service packs/security
patches to the 2 instances ?
2) If i need to restart the SQL instances, how do i do it ? I ...more >>
Outlook Client on SQL Cluster Posted by Adam Maltby at 4/30/2004 9:13:28 AM Hi,
We currently have a two node sql cluster running SQL Mail.
At present we have to manually start up outlook so the mail client works.
I have been looking at the resource options and wondered if it was =
possible to setup outlook client as a resource and if so, what reg keys =
would I nee...more >>
Linked Servers and Cluster Posted by anonymous at 4/30/2004 6:52:51 AM I am having an issue using linked servers on
active/active cluster. I have two instances, and when
both instances are on the same machine, things work as
expected. When I move one of the instances to the other
machine, it does not. It appears to work correctly when I
link the named instanc...more >>
Clustered Sql Server(Again) Posted by aculfa at 4/29/2004 4:20:36 PM I should take offline backup at midnight after stopping our sql server 2000.
But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
(written in MSDN site), also the passive server brings sql server online and
cancels offline backup.
How can I stop my clustered Sql Server a...more >>
MSDTC and multi instance cluster Posted by Hassan at 4/29/2004 9:31:57 AM From BOL
"When MS DTC is running in clustered mode, only one node in the cluster runs
the MS DTC transaction manager at a time."
So if i have setup a multi instance cluster with each instance on each of
the 2 nodes in the cluster , how does MSDTC work for both these instances ?
Using Win200...more >>
Old SQL Cluster to Join a New Domain? Posted by Bonehead at 4/29/2004 9:00:23 AM Hi. In general terms, what would be the steps to have my
SQL2000 (on W2K OS) 2 node-clusters join a new domain?
They are member servers authenticating with a W2K DC on
their subnet, but we would like to install W2003 on that
DC (bare-metal NO upgrade, due to past history of AD
replication...more >>
Restore fails - LOADING state Posted by Jim Trowbridge at 4/28/2004 12:46:10 PM We run a two node cluster, with all resources currently on one node. The server is working no problems - but..
We try to restore a backup and it completes, but leaves the database in LOADING status, without doing anything
We have had this failure when the cluster is not all on one node, we have t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Regarding Active-Active Cluster Posted by Harsha at 4/28/2004 11:51:33 AM Is their any document avaiable on Active-Active SQL cluster
on microsoft site. If yes can some one please send the link...more >>
Adding Spindals on Cluster to SAN Posted by Dave at 4/28/2004 11:41:04 AM
How much work is it to add spindals to a drive on a
Windows 2000 Advanced Server clustered on a SAN?
Thank You,
Dave...more >>
Backup Distribution Database Posted by Mike at 4/28/2004 11:36:30 AM
Should a distribution be backup?
Thank You,
Mike...more >>
how many clusters can i set up ? Posted by Hassan at 4/28/2004 9:28:25 AM A slight confusion. I have created a windows cluster with 2 nodes and a
single instance of SQL 2K cluster
Is it possible to create many windows clusters? I was looking at the Cluster
Admin and there is an option to create a new cluster ... Why would one want
to do that especially with only 2 n...more >>
Service Posted by Bob at 4/28/2004 7:10:34 AM Folks,
My question is what should the SQL service and SQL agent
service be set at. Should it be set to start automatically
or manually?
Thanks,
B
...more >>
SQL 2005 (Yukon) question Posted by KA Kueh at 4/27/2004 9:46:33 PM Dear all,
Does anyone know if the next version of SQL will support load-balancing as
well as fail-over clustering? Thanks.
Regards,
Kueh.
...more >>
Multi Instance Cluster Question Posted by Ronald at 4/27/2004 3:42:09 PM I decided to try and setup a multi instance cluster on my
own and seem to be fairly successful . Its SQL 2000 EE on
Windows Server 2003 EE
Just had 2 questions. When i installed the second
instance, it asked me for a virtual name.. so i gave it
one ..in my case SQL2.. and then was asked f...more >>
Need Help for installing and configure SQL cluster Posted by Sameer Prabhune at 4/27/2004 1:51:02 AM I am trying to install an Active/passive cluster of SQL 2000 on a Win2003 machine. Can any one give me details stapes how to configure it same and what are the procedure I have to follow
I can firm windows cluster properly but do I have to install SQL server on all cluster nodes or no need for sam...more >>
Exchange cluster Posted by IFreyre at 4/26/2004 7:35:19 PM Dont know clusters, just starting to look into them. I do, however, have
needs for fault tolarance. Starting with our email server. Sounds to me
that Clustering is a bit over kill for an Exchange server or 12gig database
to be useing as a fail over system. I'm i correct in making this
assump...more >>
Active/Active Cluster Posted by BeerBoy at 4/26/2004 9:46:04 AM
I am trying to install an Active/Active cluster of SQL2000 on a Win2003 machine. I installed the default instance and a named instance. When both instances are on the same machine, they come up correctly. However, if I fail the named instance over to the other node, it will not come up. If I then f...more >>
Unable to view drives Posted by Theo Jones at 4/26/2004 9:34:31 AM We are working with a Windows Server 2003/SQL 2000
cluster. We have split our SAN volumes into three
separate drives. From Enterprise Manager, we are only
able to view one drive, which is the SAN drive the SQL
system data was installed. We tried going through
creating a new database, ba...more >>
Scenario Posted by Johan at 4/23/2004 7:02:39 PM Consider the following scenario:
I got 2 webservers (2003) using NLB.
I want some kind of common data store (SQL Server).
I need this data store to be fault tolerant.
I don't have any more machines.
I don't have an enterprise licence for windows.
How do I solve this???
...more >>
Unistall/Reinstall of Cluster Services Posted by John Hubbard at 4/23/2004 1:56:41 PM I have a need to unistall cluster services. This is on a Win2ksp4 server
with Sqlserver2ksp3. Currently only one side of the cluster is setup. No
failover server is configured at this point. I am testing on a sandbox
server. After having all the software installed and working, I uninstalled
clu...more >>
Failover Issue Posted by Dylin Mikals at 4/23/2004 9:42:57 AM I am setting up an Active/Active cluster with one
instance of SQL in each node.
When I am failing over from one node to the other, the
SQL Server, SQL Server Agent, and SQL Server Fulltext do
not come online. The state is listed as Online Pending.
The physical disks, SQL IP Address an...more >>
Active/Active ClusterInstall Posted by John Wang at 4/23/2004 9:36:27 AM How do you install SQL server in Active/Active cluster?
We want have an instance of SQL running on each of two
nodes. What different when installing it like this
versus Active/Passive?
Thank....more >>
Cluster with 1 server ok second not Posted by Colemont Bert at 4/22/2004 11:28:07 AM Hi all,
The problem that we have:
We have a SQL cluster which contains 2 windows Adv servers, server X and Y
Y is the primary node, and on that node is a virtual SQL installed, X is the
secondary node, but it needs to be reïnstalled,
as there is a db running on the cluster, I wonder if it w...more >>
act/pass cluster upg from geerhead... Posted by wadeing in vain at 4/22/2004 10:02:54 AM following up on the geerhead message:
first, uncluster the SQL then reboot node1
second, upg the sql 7 to sql 2000
third, upg the sql 2k to sql 2000 cluster instance...
OK...are there any upgrades to node2? Or will thw sql 2k
cluster instance take care of that?
...more >>
Offline Backup Posted by aculfa at 4/21/2004 4:40:59 PM Sorry, this on may be a very easy question for this group but I've to find
the right answer until weekend.. : ))
I should take offline backup at midnight after stopping sql server 2000.
But it's prohibited to stop by writing a task like "net stop MSSQLSERVER"
How can I stop my clustered Sq...more >>
SQL 2000 database disappear Posted by Nick White at 4/21/2004 7:48:02 AM Hi SQL folks,
We had a database just disappear. It shows up in Enterprise Manager, but
the MDB and LDB files are just gone. All the other databases are there, and
working OK also. Could something like disk corruption cause this? No one
has logged into the server for a long time, so I know ...more >>
logshipping question Posted by biju george at 4/21/2004 5:15:04 AM Hi Guys,
i am planning to implement logshipping in sql 2000 which
is already a pulisher for transactional replication.
i am planning to take transaction log backup in the
interval of 1(one) minute.
if network connection broken will it affect restoring at
desination server?
can i make the...more >>
Moving SQL-cluster to a new domain. Posted by Johnny Lundgren at 4/21/2004 12:16:03 AM Hello
Articleno: 269196 and 319016 are describing how to move cluster servers to a new domain and changing domain for a SQL2000 failover cluster
My question is concerning article 319016
There is a description on how to run the SQL2000 Setup program, altering in registry etc
But, should I do t...more >>
Failed installation to cluster Posted by Simon Call at 4/19/2004 3:17:27 PM I have a 2 node cluster on which I am trying to install a
virtual SQL Server.
I am able to complete the setup process, but the
installation fails after checking the cluster resources.
In the application log I see that the ports have
automatically been disabled (as I'm installing SQL from a...more >>
Mount Points Posted by NYCTECHGIRL at 4/19/2004 2:26:06 PM I've read in clustering articles that mount points are not supported. I've also read that they are. Which is it
Has anyone implemented them in a SQL MSCS cluster
Thanks...more >>
Cluster SQL 7.0 in W2KAdv environment Posted by rene.fontan NO[at]SPAM winterthur.es at 4/19/2004 2:24:04 AM Hi!
This is the scenario:
* Windows 2000 Advanced Server clustered with 2 nodes
After the installation of SQLServer in the first node, does not appear
the 'SQL Server Failover Cluster' or 'Failover Cluster Wizard' in the
program files menu, and the option 'MSDTC Administrative Control' is...more >>
Confused...SA Account Posted by Marc at 4/17/2004 11:51:30 AM Hi
I have a two node cluster with SQL2000 SP3. When the node1 fails over to
node2, the SQL Server Agent fails. The log file says "Login Failed for user
'sa'" I don't understand how the SA account can fail on node2 and not on
node1. Can anyone shed some light on this and possibly how to resolve...more >>
replacing node in a 2 node SQL clustered environment Posted by Michael Trantow at 4/17/2004 10:01:05 AM Do any guidelines exist?
Situation: Active passive 2 node cluster using SAN drive.
For starters I'm thinking:
1. back up all SQL databases located on shared SAN drive.
2. uninstall clustered sql.
3. uninstall clustering
4. re-install clustering with node 1, new node 2
5. re-install cluste...more >>
MSDN Posted by J O Holloway at 4/15/2004 3:08:58 PM Does the MSDN subscription allow me to set up an active/passive cluster for
test/dev ? TIA
...more >>
Multiple-Instance Cluster Posted by Lucian at 4/15/2004 1:40:02 PM Situation: Two nodes, two nodes are active, two virtual
servers, two separate applications. One active and one
wait on each. Active on each fails over to wait on each
other server so that I should only lose one application at
a time.
Question: Two SQL instances on each node/virtual serve...more >>
How do I register or access SQL Server in a Clustered environment? Posted by Ron Michaels at 4/15/2004 10:06:12 AM I have been working as SQL server DBA on standalone
servers for about 3 years. I have been using SQL Server
2K Personal Ed. on my pc to do most development and to
register standalone test servers. I have never worked in
a Clustered environment. I have recently been put in a
SQL Server 2K ...more >>
NAS or direct attached storage Posted by Ken Shaw at 4/14/2004 6:13:04 PM Am I right in saying that you can't implement a failover SQL Server 2000
cluster using NAS? Ie - you have to be using direct attached storage (like
a big SCSI array) correct?
Cheers,
Ken
...more >>
active/passive cluster upg Posted by geerhead at 4/14/2004 10:20:40 AM I have:
-nt 4 enterprise w/ sp6a
-MSCS Active/Passive
-sql 7.x enterprise w/ sp3
I want to upg the SQL 7 to SQL 2000.
Do I:
-Upgrade server 1 to sql 2000, then move the group to
server 2 and upg it?
thank you...more >>
'Virtual Server' option not available when installing SQL2000 on Win2003 Posted by cterrell NO[at]SPAM earthling.net at 4/14/2004 7:46:45 AM I have a 2-node cluster working properly and have setup a pipe name
alias for the virtual server instance (as per KB article Q815431).
When I start the install of SQL 2000, the second screen that allows
you to choose Local, Remote or Virtual Server has the Virtual Server
option greyed out. Am I ...more >>
Assertion error Posted by MacManaman at 4/14/2004 1:01:04 AM Can anyone provide help regarding recbase.cpp , record.inl assertion error
New cluster system, W2K3 Datacenter, SQL2000+SP3a, IBM x445 Two-way SMP (16CPU,64GB), EMC Symmetrix DMX800
Two instances of SQL Server...
Keep getting assertion error on named instance wich uses MSDTC(msdtc working correct...more >>
Cannot Connect using IP to Clustered Named Instance Posted by MCDBA Wannabe at 4/13/2004 3:34:54 PM I am having trouble connecting when using the IP address to a named
instanced using dynamic port assignments and hosted on a 2K3 cluster (even
when at the console on the node hosting the SQL instance). I receive "SQL
Server does not exist or access denied". There are no entries created in
the ...more >>
clustering error Posted by Man at 4/13/2004 12:57:23 PM i got active\active clustering environment
when i went to clustering administrator i see in cluster
groups the 2 nodes are having red x mark what does it
mean as all the resources[disk] in two nodes are online
while one resource[mssq] in each node is failed in
1node and partially f...more >>
Distributed databases in a cluster Posted by AA at 4/13/2004 12:20:14 PM Hello gurus!
I know that SQL 2000 and very probably Yukon SQL do not support a shared
disk cluster.
So, in the shared nothing schema is possible to (in a Active/Active):
having one SQL 2000 instance running in the Active1 Server with on Database
(like pubs) and in the Active2 Server another...more >>
SQL Server Multiple-Instance Cluster Posted by Earl Spooner at 4/13/2004 10:12:40 AM I am planning on a two node cluster with multiple
instances. I will have two databases and two separate
applications will be going against them. I want 'APP 1'
to go against 'DB 1' on 'NODE 1' and failover to 'NODE
2'. I want 'APP 2' to go against 'DB 2' on 'NODE 2' and
failover to 'NOD...more >>
clustering Posted by Man at 4/13/2004 6:41:50 AM in clustering groups i got two nodes node 1 is howing
failed and node2 is showing partially online what does it
mean but resources shows online...more >>
sql server license for active passive mode Posted by Raj at 4/13/2004 6:39:28 AM Hi,
if I have a cluster of servers ( 2 to be exact), do I need
one copy of sql server or one for each server ?
Thanks...more >>
(Cluster) Memory settings Posted by AA at 4/12/2004 4:36:43 PM Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have dif...more >>
(Cluster) Memory settings Posted by AA at 4/12/2004 4:36:27 PM Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have dif...more >>
Memory setting on a Cluster Posted by AA at 4/12/2004 4:29:16 PM Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machine has 4 GB o Physical Memory (RAM), but I want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory confi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |