Groups | Blog | Home


Archived Months
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
all groups > sql server clustering > april 2004 > threads for april 15 - 21, 2004

Filter by week: 1 2 3 4 5

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 >>


DevelopmentNow Blog