| 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 Downgrade cluster to single-node and use local storage? Posted by AdsterUK NO[at]SPAM gmail.com at 8/14/2006 5:25:24 AM Hi,
We've got SQL Server 2000 on a W2K3 2-node cluster, however its
starting to seem that the shared storage is unreliable/failing. Is
there any way to drop the cluster to single node and then shunt the
database onto the local storage of that machine? I've found posts
indicating it could be...more >>
Clustering sql server 2005 Posted by haian at 8/14/2006 1:33:02 AM Hi everybody!. Sorry for my English skill. Can anyone help me how to
clustering sql server 2005 in Windows 2003 server? I had tried in Google but
I couldn't find any documentation
Thanks for all replies...more >>
Cluster and Instances Posted by MaDS at 8/14/2006 12:00:00 AM Hi,
Can I install more than one "named instances" on a vitual clustered SQL
Server2005?
If so, How can I?
MaDS
...more >>
Choosing physical archi for a new SQL 2005 implementation Posted by SalamElias at 8/13/2006 12:52:01 PM Hi, Currently I am confronted with an issue to estimate how should we
organize or what should we buy in order to provide high availability and
efficient response times.
I have 3 different DBs one which have high read activities, one has high
Read-write activity and the third one is for Bizta...more >>
SQL Server 2000 + Remote Mirroring Posted by SMaxwell NO[at]SPAM NationalExpress.com at 8/13/2006 10:08:03 AM Hi All,
We are in the process of setting up a DR environment for our core
systems. I'm torn between a couple of idea's where I'm not sure where
to head, so need some advice...
Our Data Centre has 4 x 2 Node Clustered SQL Servers and 4 individual
SQL Servers. Our remote site (head office) is...more >>
Create an new Instance in a clustered SQL2005 Posted by MaDS at 8/12/2006 9:13:01 PM Hi,
I'm new to SQL2005 so if this question is a stupid one please forgive me.
I have setup a clustered SQL2005 with a default instance.
This is working fine.
Now I want to add 3 more instances to my cluster.
How can I do this? I can't find a proceudre that talks about this.
So I tried so...more >>
Clustering Server Multiple Instances Memory Questions Posted by Stanley at 8/12/2006 12:00:00 AM Hi there,
Here is the situation:
Current config:
Two nodes clustering multipe instances SQL Server 2000, in Windows Server
2003 Enterprise Edition.
SQLA, with 16GB memory, set maximum 9GB memory.
SQLB\INS1, with 16GB memory, set maximum 5GB memory.
I would like to add another active node...more >>
Local Drive Letter dose not show up in SQL manager. Posted by Shutt, Robert at 8/10/2006 4:04:26 PM Team:
I have a Cluster server in a SAN with Drive SAN drives attached to the
Cluster server, running SQL 2000.
I just added another drive volume H:\ as my backup drive to run all my SQL
backups to disk. When I added the volume to the cluster and put the disk in
the same resource group as my...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
locked file on 2005 sp1 install Posted by Will D. Robinson [MVP] at 8/9/2006 12:10:05 PM We are installing SQL 2005 SP1 on a 2 node single instance windows 2003
cluster. During the install I receive a box stating i have locked files.
The file is c:\program files\microsoft sql
server\90\shared\svrenumapi.dll(wmiprvse.exe). I have read the KB article
that provides a fix for lock...more >>
Full text indexing only works on one machine Posted by Beak B. at 8/9/2006 12:03:02 PM We have 2 boxes running clustered windows enterprise OS 2003, SQL server 2000
sp4, also clustered. Everything runs fine, except when we do a failover of
sql to the other node, full text indexing will not index. The properties
come back with an item count of 1. The only "errors" i can find a...more >>
Installing SP4 on multiple instances in a cluster Posted by Gary at 8/9/2006 6:07:02 AM Hello,
I'm looking for solution of minimizing downtime(amount of reboots) when
installing SP4 on 3-node cluster running 8 SQL2K instances.I anderstood from
readme file that after each instance installation boot of all nodes in a
cluster required.
It poses a problem for us since too long do...more >>
Clustering Hardware Requirement Posted by Batayneh at 8/9/2006 5:37:01 AM Can anybody provide me with specific hardware and software requirements for
Two nodes SQL Server Cluster.
Thanks in advance.
...more >>
SP1 on Clustered Windows 2003 Server Posted by Paul Mu at 8/8/2006 11:41:02 PM Hi,
We would like to apply SP1 to our Windows 2003 Enterprise Cluster server.
The Cluster server is on a SAN with an active/passive setup. The main service
running is SQL Server 2000 Enterprise. Is there anything that I need to know
from a DBA perspective?
--
Paul
MCDBA, MCSE...more >>
monitoring sql server box Posted by John Smith at 8/8/2006 5:07:58 PM I would like to find out if there are any free tools that could be used to
monitor a sql instance and list the
a. most frequently run stored procedures and how long each takes
b. most frequently run views and how long each takes
netiq used to have app manager - is that still available ?
...more >>
use of different spindle for log files? Posted by _Stephen at 8/8/2006 4:06:36 PM I have set up my A/P cluster, and SQL 2005 sees my data partition of my RAID
for the data no problem.
How do I get to use my second partition of the RAID for my Log files? Yes I
have a third partition for the Quorum.
I can restore the db from a USB device that is plugged into the Active n...more >>
SQL Browser Service on Cluster Posted by BEACHDBA at 8/8/2006 7:07:02 AM I just noticed that the SQL Browser Service is set to run automatically in a
default-instance clustered install, whereas it is disabled in a
default-instance single server install.
Is there a reason to run the SQL Browser Service in a cluster if you are not
using named instances?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |