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 > january 2006 > threads for january 15 - 21, 2006

Filter by week: 1 2 3 4 5

Moving SQL 2005 DB's
Posted by Kevin Antel at 1/19/2006 2:28:31 PM
2 Questions Actually! 1. I know how to move all the system DB's in 2000, but I am a bit confused as to how to accomplish this in 2005. I need to move: Master Model MSDB I've already moved Temp. 2. Now, there is this other DB, called the resource DB, which they tell you not to re...more >>


Clustered SQL 2005 Standard
Posted by Kevin Antel at 1/19/2006 1:02:53 PM
I just completed an install of SQL 2005 Standard into a newly formed cluster. I basically installed every option for SQL 2005 Server, however, the only resources added to the cluster group were SQL Server, SQL Agent and SQL Server Fulltext. I would have thought reporting services would hav...more >>

Reboot SAN of SQL Cluster
Posted by RobinMC at 1/19/2006 10:09:03 AM
We are planning a recycle of our SAN to which our active/passive 2-node SQL cluster is attached. Is there anything special to be aware of? We will do the following steps: Pause the passive node using Cluster Admin, stop SQL service Power down active node server power down passive node serv...more >>

Cluster DR
Posted by John Smith at 1/17/2006 4:53:49 PM
My production cluster disks are corruptd - i would like to find out how to restore from backups I have all system backups and mdf and ldf files of the databases - I would like to keep the logins, jobs etc Thanks ...more >>

Cluster Upgrade
Posted by Seme Rollansa at 1/17/2006 4:50:07 PM
Hi, We have a cluster (2node, 8Way, 8GB) running windows 2000 Advanced. We would like to upgrade to windows 2003 Enterprise Edition Whats the easiest way to accmplish this ? what are the options ? are there any links ? ...more >>

Reboot? How often?
Posted by rk rider at 1/17/2006 10:10:03 AM
We currently have SQL server EE running on Windows Server 2003 EE in a 2 node active/passive cluster. We want to restart periodically but not too often. What is the best way to do this? What I've been doing is move the resources to the inactive side of the cluster then rebooting the passive no...more >>

Newb question regarding cluster load balancing
Posted by Michael Weyant at 1/16/2006 10:45:38 AM
Hello to all, I am currently working on creating a Windows 2003 server cluster (3 nodes) with the intent that it serve our web app which requires multiple SQL databases. The question I have is this: How can I configure load balancing for this? It seems that clustering services only allows 1...more >>

SQL Hotfixes - Adding New Node to Cluster
Posted by Norb at 1/16/2006 6:37:02 AM
I have a 4 node Windows 2003/SQL 2000 cluster that started out as a three node cluster. I just added another node and new instance. Everything went great on the Windows/cluster side, everything fine on the SQL side for that instance. When I went to add the new node to the other two inst...more >>



SQL Timeout
Posted by naruphon at 1/15/2006 1:35:00 AM
My application record the SQL Timeout in the log file. The application server calls SQL on cluster via ADO. The error is always when the batch processing is running. Can anyone here advise me on how do I expand the time-out on SQL cluster? I am using SQL 2000 SP3 Best Regards, Naruphon ...more >>


DevelopmentNow Blog