| 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 to control DB size growth? Posted by Tom at 1/14/2005 11:21:04 AM Hello,
My database is 1gig big and it has so far one table with 1 melion records.
Once I tried to create the primary key in this table but it was rejected by
MS SQL since it was not unique. That's fine with me but I noticed that my
database doubled in size to just over 2 gigs. Then I create...more >>
Clustering, sending mail from SQL Server in a cluster Posted by Cqlboy at 1/13/2005 1:53:03 PM
We consolidated sending SQL Server mail from one box in our enterprise,
which has worked out well for us. Now we'd like to consolidate
servers/databases and put it under a clustered environment. But how do we
handle the mail ?
Thanx.
-Cqlboy...more >>
Changing cluster configuration Posted by Jerrick D.H at 1/13/2005 9:51:02 AM My current cluster configuration is Active/Passive, I'm exploring a change to
Active/Active, but I haven't been able to find any informaon on how to do
this, has anyone ever done this? My reason for considering this is the size
of the current server, and the need to bringup other applications...more >>
Rebuild one node of an active/passive cluster Posted by Tom at 1/13/2005 9:47:10 AM Is there a documentation on how to rebuild one node of an active/passaive SQL
Server cluster from the O/S up with the SQL Server in use by the other node?
...more >>
2 nodes active/passive cluster for SQL Server not failovering correctly! Posted by Scott at 1/13/2005 1:06:54 AM I have a 2 nodes active/passive SQL Server 2000 cluster running on a Windows
2003 server cluster.
When I shutdown the active node and then the failover is starting to work.
I can see all of the SQL Server services has failovered to passive node in
Cluster Manager and no error or warnning m...more >>
Physical drives still appear on passive cluster node in active/passive 2 node cluster. Posted by Tim Watts at 1/12/2005 4:03:37 PM I am in the process of setting up a new exchange cluster on a pair of Dell
servers.
I have three physical disks that appear in the disk management console. On
the primary node I wrote a signature to each of them while the secondary
node was offline. I then created partitions on each of the ...more >>
MSDTC resource in a Cluster Posted by Joseph at 1/12/2005 11:42:57 AM I've read and heard some conflicting information about the best method for
setting up a MSDTC resource in a cluster. I am running MSSQL 2000 SP3a and
Windows 2003. 2 node cluster with currently only once instance of MSSQL
with a great chance of growing.
A few questions I have:
Should the re...more >>
MSDTC on server 'VirtualServerName' is unavailable Posted by pleblanc at 1/12/2005 10:47:06 AM I have a 2 node active/passive sql server 2000 sp3a running on Windows 2003.
Whenever I run a distributed query I get the following error:
MSDTC on server 'VirtualServerName' is unavailable
Does anyone have information regarding this problem?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Cluster Addresses Posted by jimmy at 1/12/2005 6:45:07 AM Hi,
I am a newbie to Clustering so please bear with me.
We have a db environment set up with Win 2003 and SQL 2000 connecting to a
single disk array.
The question I have is, what is the difference between the Cluster IP
Address and the SQL IP address.
What I really want to know is what...more >>
Migrate stand alone sql server to a cluster without downtime Posted by Yuhong at 1/11/2005 8:27:04 AM Hi
I have read most the articles and posts about move sql server.
Here is my situation:
I have stand alone standard sql server 2000 and with about 40 databases. And
I am moving the server to a SQL cluster(Active/passive). I have to use the
old name, IP on the new server and with minimum down...more >>
Full-Text Indexing greyed out Posted by Alistair Keay at 1/11/2005 6:57:05 AM Problem
Full-text indexing option is greyed out in the enterprise manager.
Setup
SQL2000 sp3a running on windows 2003 cluster. (Default install with SQL
Fulltext)
All resources are on line, including SQL Server Fulltext.
No errors reported in the event log.
Changes Made which may have an...more >>
user and group permissions Posted by Gabriel at 1/10/2005 7:28:16 AM Hello,
Is it possible to deny access to local NT administrator
and one specific domain user on sql server cluster? The
cluster runs under domain user account with adminstrator
privileges on the local machine, I have another domain
user account, it is my personal account - but this one
s...more >>
Limitations of Heartbeat/clustering Posted by Quiggley at 1/9/2005 11:09:02 AM If I want to put one server in one datacenter and the other server in another
datacenter what are the limitations of the heartbeat? ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |