| 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 MS-Access front-ends lose connection to SQL cluster after failover Posted by JJP at 6/21/2004 2:10:32 PM Hello,
We are setting up a 2-node active/active SQL 2000 cluster on Windows 2003
ent. ed.
Our DB team writes MS Access XP front-ends for client connection to SQL
cluster.
NODE1 and NODE2 are working fine. I can fail INST1 over to NODE2 and INST2
over to NODE1, vice versa, all is good.
Ho...more >>
High Availability Posted by Greg at 6/21/2004 3:05:02 AM Does anyone have a good starting point for creating a "high availabilty"
solution. I'm working on designing a solution that will allow for us to have
a primary site in Orlando and a secondary site in another state. The system
needs to have data moving in almost real time between the master and
s...more >>
Olap Question Posted by biju george at 6/20/2004 1:49:24 AM Hi Guys,
i am managing an OLTP system using sql 2000 and these
system is running for last 4 years and now having 25
million records for main transaction table.
is it advisable to go for OLAP Systems to get fast summary
report.
if so pls advice me how i should start.
Thanks
Biju...more >>
Deleted SQL Resouce Posted by SQL Resource Deleted... Help!!!! at 6/19/2004 7:08:01 PM i was deleting a disk resource from our cluster, the sql resource depended on that disk, when i was asked about deleting the dependent resources i clicked the delete option, so now i dont have any sql resourse. now i can´t see my SQL anymore even whe i try to create a sql resource manually.
Wha...more >>
SQL Server Clustering on a NAS Posted by anonymous NO[at]SPAM discussions.microsoft.com at 6/17/2004 12:08:23 PM
Is SQL Server clustering supported/recommended using a
NAS/RAID to hold the database? Here is the hardware setup
Let's say there are 25 computers on a network. Two of
these computers are running as a 2-node SQL server
cluster. The database resides on the Z: drive. The Z:
drive is a NAS....more >>
SQL 2000 server cluster Log shipping Posted by newby at 6/17/2004 10:31:08 AM Currently, we have two sets of SQL 2000 cluster servers in two different regions. We are trying to implement log shipping for redundancy. Does log shipping require a share from the Operating System stand point?...more >>
SPN Error Posted by -DB at 6/17/2004 7:53:41 AM We have a SQL 2000 cluster that is running on two Windows 2003 Enterprise
boxes and everything works fine, except that after the cluster has been
running for a while (24 hrs.), if you fail the cluster over to the failover
node, then when you go to fail it back to the primary node SQL spits an SPN...more >>
"Cluster-aware" Applications Posted by anonymous NO[at]SPAM discussions.microsoft.com at 6/17/2004 6:03:52 AM
If a customer has a na application that accesses SQL
server running on a single machine (Windows 2003 Server)
and then decided to implement an active/passive server
cluster with SQL Server Enterprise, does the application
that accesses the database need to change? I am not sure
what is m...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
leaving production SQL Standard alone while setting up Node 1? Posted by The American at 6/16/2004 3:30:42 PM Hello.
I was given the task to cluster our existing standalone W2K SQL server.
I've purchase a new server from Dell along with an external SCSI array plus
2 SQL2K Enterprise and 2 W2K Advanced CDs for both servers in my future
cluster.
We have an existing W2K SQL Standard running on a W2...more >>
BULITIN\Administrator Posted by johnx02 NO[at]SPAM hotmail.com at 6/16/2004 3:16:32 PM Security Best Practices tell us to remove BULITIN\Administrator from
SQL Server Logins. Is this also true in SQL Server 2000 Cluster.
Many Thanks
John...more >>
Newbie question Posted by GeorgeP at 6/16/2004 1:09:59 PM I am looking to go into a DBA role and I keep hearing
about clustering servers.
Is there anywhere I can go to learn about it? Or can
someone please tell me what it is and how to set it up?
Thanks,
GP...more >>
Partitions as SQL Server Resources in Clustering Services Posted by twillard NO[at]SPAM generasystems.com at 6/16/2004 1:03:24 PM I've got 2 Arrays on my SAN.
Array 1 is 66 gb.
Array 2 is 230 gb.
I've partitioned the drives in MS2003 this way:
Array 1, Drive Q: (Quarum) 2gb
Array 1, Drive S: 64gb
Array 2, Drive R: 230gb.
I installed SQL Server after setting up MSCS.
Everything went fine.
Now I want to add the ...more >>
sql2000ent software scam ???? [slightly off topic] Posted by Dave V at 6/16/2004 11:17:50 AM I'm not sure this is on topic for the group, but someone here would know
I have a question about a too good to be true deal on ms sql server 200 ent
1 processor license being listed for sale on saveintheusa.com for $3,245.
This just seems completely unreasonable considering the list price is 20...more >>
SQL Server Licensing Posted by Todd Harrington at 6/16/2004 7:07:39 AM
Hi,
We want to run a two node server cluster with Windows
Server 2003 Enterprise and SQL Server 2003 Enterprise. How
many copies of SQL Server Enterprise (1 Server, 25
clients) do we need to purchase, 1 or 2? Since it is only
actively running on one server at one time, I would think
w...more >>
Problem with sql2000 cluster installation Posted by Hi,
i try to install a SQL2000 on Windows 2003 Ent.; i enable Network DTC and
manually configure a MSDTC Resource reading the article :
http://support.microsoft.com/default.aspx?scid=kb;en-us;301600
http://support.microsoft.com/default.aspx?scid=kb;EN-US;811054
After verified the MSDTC Re...more >>
Adding node to cluster Posted by Erik at 6/15/2004 11:52:03 PM Hello everyone!
We currently have a one node cluster (w2k3 and sql2000ent) and have had it
this way for a while waiting on the second server to arrive, well, the time
has come and now we are about to install the second node in this
active/passive cluster.
I have been reading in booksonline ...more >>
SQL Server Memory Configuration Posted by Karen at 6/15/2004 2:05:36 PM Two 4GB mem clustered sql servers. Two sql instances. If
leave 1GB for the OS. 1.5GB for each instances. Still need
enable AWE?
Thanks a lot!!!
K....more >>
Stand-alone to Cluster upgrade Posted by Robert Reinstein at 6/15/2004 1:42:32 PM Hi,
If I have an existing SQL 2000 server that I want to move into a cluster,
will I need to reinstall from scratch, or can I simply upgrade the OS to
Enterprise, then upgrade the SQL to enterprise? Of course, my goal is to
leave the data intact (the data is already stored on a SAN, not local).
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |