| Groups | Blog | Home |
|
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 How many SQL 2000 nodes does Microsoft Officially Support on 2003? Posted by John Robel at 1/13/2006 4:05:02 PM I would like to know if I can move my active/passive SQL clusters into a more
cost effective four node cluster (3 active and 1 passive). Is there a matrix
or document somewhere on Microsoft's site that indicates what configurations
are officially supported and considered "best practices"?
...more >>
Implementing sql Clustering at first time. Posted by Maria Guzman at 1/13/2006 9:01:01 AM Hi, In the company where I Work, decide to implement a sql server cluster. I
want to ask, I somebody know any issue I have to consider or any sites that i
need to visit before implement it.
At this moment, i have a server running win2k server sp4, sql server 2000
sp3 std edition.
Thanks ...more >>
Copying database file to another drive fails Posted by ronc at 1/13/2006 6:28:01 AM I have an active/passive cluster involving 2 machines. I have 3 instances
running on the production server. One of the drives allocated to instance 2
was running out of space so I decided to move one of the larger databases to
another drive that can handle its size. The drive that I was goi...more >>
Multiple Instance use of MSDTC Posted by Howard at 1/12/2006 11:50:37 PM I have set up a
multiple instance
SQL server and I'm
trying to
understand how both
instances are able
to use the same
MSDTC resource.
Specifically,
Server 1 is the
primary host for
instance 1 (server
2 is the backup for
instance 1).
Server 2 is the
primary host for
instance 2 (...more >>
SQL 2005 Clustering Posted by msadexchman at 1/12/2006 5:52:46 PM Hello,
I've set up a few two node active/passive SQL 2000 clusters in the past but
now a client is asking for a two node SQL 2005 active/passive cluster. I'm
assuming this is still possible in 2005 but just can't seem to find any good
resources related to SQL 2005 clustering. Can anyone p...more >>
Quorum Disk Question. Posted by DRay at 1/12/2006 12:17:03 PM We will be setting up a Windows 2000 SQL server on a two node 2003 Cluster
connected to an HP SAN.
Reading through the whitepapers and watching the webcast on how to setup
everything says to keep the data files on a seperate disk from the quorum
drive.
This will not be a problem, however...more >>
Warning Event ID 1137 on cluster Posted by Jon Macy at 1/12/2006 11:51:02 AM We have a SQL 2000 SP 3a Active/Active Cluster running on Win2K3 SP1 servers.
Servers are big iron - plenty of memory, processors, GB Network, etc.
Every once in a while (usually 3 or 4 times a day), I will see a rash of
Source: ClusSvc
Category: Event Logger
Type: Warning
Event ID: 1137
...more >>
Quorum Disk or Majority Node? Posted by Kevin Antel at 1/12/2006 11:33:59 AM New to Windows MCS 2003 is the Majority Node Set option, does anyone have
any experience where Majority Node is better than Quorum or vica versa?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQLServer Agent Properties/Connection/Windows-SQL Auth Posted by shorefisher at 1/11/2006 12:15:55 PM Books online says clearly that on the SQLServer agent properties
(Connection tab) you should select Windows authentication if you are
running on NT or Windows 2000. It doesnt't say why. My version of Books
doesn't give a recommendation for Windows 2003.
Most of our instances don't seem to ca...more >>
Cluster Set up Question Posted by mvp at 1/11/2006 8:13:02 AM Hello,
We are implementing clustering (Active/Passive) in our Production environment.
So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
ProdDbServer2)
I will install SQL Server on both the machine and i will create my database
(FinDB)
on both the machine's SQL SERVER...more >>
Clustering for Performance Posted by Richard at 1/11/2006 5:11:06 AM Hello All. I need to set up quite a large SQL System 2005 system that needs
to deal with 40,000 concurrent users, and one of the tables will contain blob
data. 40,000 users throwing around Mb's of data at the same time worries me a
little bit!
My question is to do with Database Clustering a...more >>
No item under Computer Management Posted by maoji at 1/11/2006 3:52:11 AM Strange issue... I have a 2-node SQL Server 2000 Cluster with SP4
applied. Everything works fine but the Veritas BackupExec program can't
find the SQL Server. When I use Computer Management to connect to the
cluster by the cluster name (and also to the active node of the
cluster), I only found "...more >>
Non Clustered Effect Posted by Travis at 1/10/2006 6:32:02 PM Hi ,
When I finish to create one non clustering index on of of my table , I
found out that the size of the hard disk increase amazingly.
I decide to drop the this index but the hard disk size did not back to
original size before that. What should I do next ? Please help
--
Trav...more >>
Is it necessary to do a Service Pack reinstall after changing or adding new software or hardware components? Posted by Sean at 1/10/2006 6:27:58 AM In: Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;254321
In Section: Important cluster service administrative rules.
"Warning If you ignore any of the following rules, you will need to
reinstall Microsoft Cluster Service.
=B7If y...more >>
add disk to a cluster running sql2005 Posted by Robert Smit ( 450331) at 1/9/2006 11:35:00 AM hi,
I have a windows 2003 sp1 cluster running sql2005.
the DB is installed on S: and i have a R: & U: drive letter that is both
differend disk and runs fine in the cluster.
But i can not see those disks in sql 2005 why ??
the disks are in the same resource group (SQL)
where can I choose t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |