| 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 Clustering without shared disk array? Posted by Dan at 5/21/2004 11:56:11 AM Hi all,
We have 3 server, compaq 570ML and try to find out the way to increase
availability and fault tolarency with MS SQL 2k server, W2k AS. I heard SQL
failover clustering is not possible without disk array, is it no way?
Regards
...more >>
Need advice on massive database Posted by Jack Victor at 5/21/2004 10:06:17 AM Hi,
We're in the process of architecting a very large SQL2K database. We
believe this database will grow 2TB per month. 99% of the inserts will be
done via bulk inserts. Approximately 3-4 per day an application that we
wrote will query and pull approximately 6 million records at a time.
...more >>
Share Database with 2 SQL Servers. Posted by Jack Victor at 5/21/2004 10:05:47 AM Hi,
Is it possible to have 2 sql servers inserting into the same database. In
my specific case, the servers would be inserting to different tables and
there would be no overlap. I don't want to split the database because
reporting would be based on data from the whole database. I guess this...more >>
Disable Fulltext Posted by Mike at 5/21/2004 8:58:33 AM
I have a server that has SQL Server 2000 with SP3A with
Windows 2000 Advanced Server with an Active/Active. We
are presently not using the SQL Server 2000 Fulltext.
How can I disable the SQL Server 2000 Fulltext service?
How could stop the service and disable the service to
restart whe...more >>
Disk exchange on two-node MS SQL 2000 active/active cluster Posted by roustam NO[at]SPAM hotbox.ru at 5/21/2004 7:01:34 AM Hi!
I have two-node cluster on Windows 2000 Adv Server sp4. There are two
instanses of MS SQL 2000 Server sp3, one on each node. I have one
physical disk owened by the first node, that is not used. I need to
transfer it to the second node, name it with the letter this node
already has (rem...more >>
Mount Volumes for SQL Server 2000 Posted by Dan at 5/21/2004 6:17:16 AM
This corresponds to the Microsoft Article 819546.
On a clustered instance of SQL Server 2000, data storage
on mounted drives is not supported.
This applies to Windows 2000 and to Windows
Server 2003.
Mounted drives are sometimes referred to
as "mounted volumes," as "m...more >>
SQL Server Full Text Posted by Mike at 5/20/2004 11:37:24 AM
I have a SQL Server 2000 Enterprise Edition on a Windows
2000 Advanced Server. This cluster is set up as
Active/Active. Periodically the SQL Server FullText
service stops.
How should I change my cluster dependency settings so that
if the SQL Server Fulltext stops it does not effecti...more >>
Clustering H.E.L.P. Posted by DBA76 at 5/19/2004 2:55:35 PM Hi,
I want to test the clustering environment before implementing the same on
production servers. The resources i have with me are high end ( p4 2G ,
512MB RAM ) personal computers. I can install 2k3 on two systems .. what do
i use for "shared storage".. can i use the shared drive of another d...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Where can we find MIB for MSCS Posted by Tom Celica at 5/19/2004 2:21:13 PM Our goal is to monitor the event when our Active/passive cluster fails over
to the second node, indicating a problem on the primary node.
We are thinking of monitoring thru SNMP with a MIB.
Question 1: Where can we find a MIB to minitor Cluster failover to the
secondary node?
Question 2: I...more >>
Service Pack Install Posted by Ken Krause at 5/19/2004 9:41:09 AM I have a concern with a clustered SQL server pair which had a failed node recently replaced with a new server. I am understanding that when I replaced the node, the install of SQL from the original node copied over all binaries, including SP3 files to the new node. But, with the original node as
a...more >>
KB article 812666 can't find??? Posted by Dude at 5/18/2004 12:25:03 PM At the bottom of KB article 827449 there is a link to KB
article 812666 which is exactly what is needed to recover
the Full text search option in a SQL cluster. By following
the link or searching can't find it. Any ideas? ...more >>
failover cluster SQL 7 - sql server agent cannot start Posted by Beth at 5/18/2004 11:36:21 AM Our failover has worked before, but this time the sql
server agent cannot start. Any suggestions at all about
where to start looking?...more >>
Web apps cannot connect after password change/ failover Posted by F at 5/18/2004 11:23:47 AM Here's an odd one; I was changing the password on a 2-node
failover cluster (via enterprise manager, of course) when
it asked to restart SQL Server (aka a failover). A normal
operation. But, after the failover completed, I was unable
to connect to SQL Server via web apps. I was however able ...more >>
GeoCluster/Windows 2003/SQL 200 and sp3a contd. Posted by suzana ciur at 5/18/2004 3:46:06 AM I thought of opening a new thread, so it does not get overlooked..
So my problem is that I can't install sp3a on a virtual SQL 2000 server, installed on a Windwos 2003 cluster
I have preinstalled MSDTC as a clustered app (according to Q301600) so I guess the install of SQL just skips it, because...more >>
Running ComClust.exe after SQL 2000 installed on Win 2K cluster Posted by jlee at 5/17/2004 2:27:22 PM Are there any issues or downtime when running ComClust.exe
on a cluster after SQL 2K has been installed? Thanks, John...more >>
Windows 2003 and SQL Server 2000 clustering question Posted by Benoit at 5/17/2004 1:26:29 PM Hi,
Is it possible for both nodes in a SQL Server 2000 cluster
to open up the same .MDF & .LDF file on the shared array
simultaneously and still be able to perform standard SQL
calls (SELECT, UPDATE & INSERT) without causing
corruption, performance degradation and/or sharing issues.
I ...more >>
Windows 2000 & SQL 7 & MSDTC log location Posted by hdjim69 at 5/17/2004 10:58:35 AM Hi,
Where does the msdtc.log file need to be located on a Win2K setup with SQL7
?
...more >>
Newbie Q: SQL Redundancy Posted by Steve at 5/17/2004 10:01:07 AM Hi, If I have two machine in a cluste
- if I install SQL on one will the installation replicate on the other or do I have to install both seperatly
- if I have SQL operating on both nodes and I write SQL to one will it replicate over automatically (does it remove the need for SQL redundancy
- wou...more >>
GeoCluster/SQL server sp3/windows 2003 Posted by suzana_C at 5/17/2004 6:51:01 AM Does any one have any experience with MS Clusters and
GeoCluster from NSI?
Also, does any one have any experience of installing sp3
for SQL Server on a Virtual SQL 2000 on a Windows 2003
Cluster?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |