|
How to control DB size growth?
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 created clastered inde ...
Fri, 14 Jan 2005 11:21:04 -0500
|
Infortrend
Anybody using and infortrend Eonstor F16F-R2A2-A with Qlogic QLA2342's with
a sql cluster.
Would really appreciate any comments on them.
Thanks
Steve
220 17045
NNTP-Posting-Date: Fri, 14 Jan 2005 03:07:54 -0600
From: "Steve Woodhams"
...
Fri, 14 Jan 2005 09:07:53 -0000
|
Clustering, sending mail from SQL Server in a cluster
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: spawar@online ...
Thu, 13 Jan 2005 13:53:03 -0800
|
Changing cluster configuration
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 on the
second ...
Thu, 13 Jan 2005 09:51:02 -0800
|
Rebuild one node of an active/passive cluster
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?
...
Thu, 13 Jan 2005 09:47:10 -0800
|
MSDTC on server 'VirtualServerName' is unavailable
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? ...
Wed, 12 Jan 2005 10:47:06 -0800
|
MSDTC resource in a Cluster
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 resource be in the ...
Wed, 12 Jan 2005 11:42:57 -0600
|
2 nodes active/passive cluster for SQL Server not failovering correctly!
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 message appear.
...
Thu, 13 Jan 2005 01:06:54 +0800
|
Cluster Addresses
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 is the purpose ...
Wed, 12 Jan 2005 06:45:07 -0800
|
Migrate stand alone sql server to a cluster without downtime
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 time. Anybody h ...
Tue, 11 Jan 2005 08:27:04 -0800
|
Full-Text Indexing greyed out
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 impact
Origina ...
Tue, 11 Jan 2005 06:57:05 -0800
|
user and group permissions
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
should have no ac ...
Mon, 10 Jan 2005 07:28:16 -0800
|
Limitations of Heartbeat/clustering
If I want to put one server in one datacenter and the other server in another
datacenter what are the limitations of the heartbeat? ...
Sun, 9 Jan 2005 11:09:02 -0800
|
Clustering an existing set of servers
I have two non-clustered win2k servers (advanced server) with SQL Enterprise
installed with local storage. Production use has already started on a limited
basis. Would it be possible to to in place clustering using the following
steps?
1. Installation and configuration of additional hardware on each sever ...
Fri, 7 Jan 2005 11:15:05 -0800
|
DBNETLIB error
Platform:
Windows 2003 ent ed, SQL Server 2000 sp3a enterprise
We tried to bcp file into our Failover Cluster SQL Server database, but with
serious error:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, ...
Thu, 6 Jan 2005 08:59:08 -0800
|