Hi, we have an active/passive cluster which hosts our production database. Transactional replication is being made from the production to a 'reporting' database residing on a lone server. We will need to install Analysis service for the construction of cubes. I was wondering where Analysis ser...more >>

Hi , When I creare a non clustered index , I get error as show below , Server: Msg 1904, Level 16, State 1, Line 1 Cannot specify more than 16 column names for statistics or index key list. 21 specified. SQL Server only support up to 16 key values ? -- Travis Tan...more >>

Can someone briefly explain why SQL Server Agent and MSSQLSERVER are currently reading: "Manual"/"Started" in Services.msc? I figure it must be a clustering thing. On the Passive node cluster the services are not started, but just manual. ...more >>

Hi, I'm using MSCS registry checkpointing to make sure my application data written in registry will be available to other nodes when they become online. I was wondering if the checkpoint operation is synchronous to the registry write or is it possible that the registry write would be acknowl...more >>

Is it possible to have different versions of SQL Server 2005 clustered as various nodes. ie: Node 1 - Sql server 2005 Enterprise Node 2 - Sql server 2005 Standard Node 3 - Sql server 2005 Standard...more >>

I have an architecture which has 4 DB servers on the whole; two will participate in load balancing and other two in fail over clustering. My question is how will the two DB servers that is used for load balancing synchronize? ...more >>

Hi, I need urgent help on SQL 2000 cluster based on Windows 2003 SP1. I have SQl 2000 cluster with one virtual server on Windows 2003 connected to HP EVA 5000 SAN. One of my node failed & did basic steps like Evict the node & so on from exisitng setup. Later I built the node again with OS....more >>

Hi, I need urgent help on SQL 2000 cluster based on Windows 2003 SP1. I have SQl 2000 cluster with one virtual server on Windows 2003 connected to HP EVA 5000 SAN. One of my node failed & did basic steps like Evict the node & so on from exisitng setup. Later I built the node again with OS. L...more >>

Been fun posting on some of these SQL newsgroups and receiving timely responses that made my day. Thanks to all who responded and also thanks to all the ones that ask questions. I only wish i could read the newsgroup postings every day Anyways Happy Holidays everyone.. ...more >>

Our production enviornment consists of 2 production servers in an active\passive set up. The production enviornment has 3 instances. Is it possible that a single instance can fail over to the standby node and leaving the other 2 behind? We think this is happeing but I thought if the server ...more >>

Hi, where I can find a guide step-by-step to add a second node to existing sql2005 cluster? I have installed an istance only on first node and now I want add the second one. I run the setup but i don't see the option to add the new node. The resources are off-line in the node that i'm going...more >>

Hi there, Just want to know is it possbile to configure a 3-nodes (A/A/P) SQL Server 2000 cluster running on Windows 2000 advance OS? Btw, any website or whitepaper can I refer to? Thanks in advance! Dicky ...more >>

We had an error over the weekend of mass porportions(Sunday 3pm PST). = Long story short; the model database was detached and the SQL Server was = stopped, with it still detached. This happened to happen on our primary = Production Database Clustered Server which is the bread-n-butter of the = ...more >>

Hi, We have an 2-node Active/Active SQL 2000 SP3a cluster on Windows 2003. Accordingly we have 2 instances of SQL, INST1 on node 1 and INST2 on node2. I think our db admin did a "no no" a few weeks back. Having an issue with something SQL related, she changed the MSSQL$INST2 service account...more >>

I have Sql 2000 on Windows 2003 server, i would like to be notified when cluster fail over accours. How can i do this. Your help is greatly appreciated....more >>

Hi, We are thinking about setting up an Active\Active\Passive configuration on 64 bit SQL Svr 2005 instances. Is it possible? Documentation available anywhere? mpighin@msn.com ...more >>

Hello What configuration for SQL Server 2000 do you suggest, to get the best possible performance. Best regards, Farenheit ...more >>

Hi, Geoff Hiten I have been having issues with SQL not starting due to the following error message: [sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818; message = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\account' I read through MSDN ne...more >>

Any documentation out there that talks about setting up a 4 node or 8 node cluster using Enterprise Edition of Win2K3 Also, there is the load balancing component of Clustering services. How can SQL leverage that ? Any link that talks about this setup too. Thank you ...more >>

Hi, one of our network technicians accidently deleted both the following registry keys on the passive side of our Active\Passive cluster configuration for SQL 2000: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server] [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer] Since we ha...more >>

I know that SQL 2005 standard has clustering incorporated in it now, so you don't need to have Enterprise version, in order to have a failover cluster. My question is, do I still need Windows 2003 Server Enterprise, to support a failover cluster, or can I get by with Windows 2003 Server Stand...more >>

Hi all I am a newbie to SQL 2005 clustering. We are trying to set up a a SQL cluster to be used with Sharepoint. If anyone knows of any helpful material, can you please point me towards it. Thanks Sam ...more >>

Has anyone set up a 4 node cluster i.e. 3 active and 1 passive ? I only want to consider this as it may reduce cost. We have a lot of servers and the least i want to do is have an active passive 2 node cluster for every server thus doubling the server costs Do let me know what you have, wha...more >>

Hi, We have a Virtual SQL Server(default instance) running on Windows 2003 Server Enterpise Edition Cluster,shared disk and quorum drive on SAN. We consider implementing a Report Server by adding a second Virtual SQL Server(Named instance) to utilize the second node,which at the moment sits ...more >>

(I'm posting this here as I am uncertain what other category it belongs. If there is a more appropriate newsgroup, please let me know.) We currently have an EMC CX300 SAN with Qlogic 5200 switches and Dell PowerEdge Servers. As best we can tell this combination fits Microsoft's Hardware...more >>

Hi everyone. It's 0:43 in the morning and I am driven crazy by this installation failure. the last part of the sqlstp.log file has been posted below. Anyone has any idea what should I post next in order to find a cure? Thanks very much! 00:18:27 Setup is performing required operations on cl...more >>

We have a SQL 2000 server that we are about to upgrade to SQL 2005. This server is running on Server 2003 standard. We would like to set up a second SQL 2005 server and either do clustering or replication so that we would be able to access our data in the event of a single server failure. ...more >>

Any pros and cons between the 2 We want to implement clustering for our SQL Servers and debating whether to use Windows clustering or Veritas Clustering Please let me know what you all think and which one would be recommended and why ? This is for SQL 2K ...more >>

Hello, I'm clustering a single node (DELL 1850 and a PowerVault). I selected it to place the quorum log on the SAN, but after the setup, it configures it with a Local Quorum and the SAN disk fail to come online. So, I'm trying to add additional SAN disk as resources to see what's going o...more >>

The master log file has been moved from its installed disk to a new disk. This disk is part of the SQL server dependancies and the changes have been made through Enterprise manager. SQL fails to restart through the Cluster manager claiming that the log file is unavailable with the followin...more >>

I have a two node active/passive win2003/sql 2000 cluster. Can I do a = side-by-side install of a sql2005 named instance on this cluster? This = is for a test environment were for a limited time (6 months) I need to = provide both a sql2000 and sql2005 environment and I would rather not = purc...more >>

I'm have created a single node cluster running on Windows 2003 Ent. X64. All the required disk resources for clustering SQL Server has been configured, a MSDTC group has also been created and configured. When trying to install a NAMED INSTANCE of SQL Server the installation fails when tryin...more >>

I have a 2 node cluster - may be grown to more node ... would like to install 4 instances, to separate databases by SLA's and workload priority ..... What are suggested naming conventions ? I have DBINST1 - instance 1 DBINST2\I2 - instance 2 DBINST3\I3 - instance 3 DBINST4\I4 - i...more >>

Hello, I have cluster on win2k3 with fresh install sql 2000 with no sp When I am trying to upgrade sql 2000 sp 4 I keep getting this error message"Setup failed to perform required operations on the cluster nodes" and upgrade fails any idea Thanks in advanced ...more >>

I have windows 2003 sp1 running in a 2-node cluster. The cluster is running sql sp4. I tried failing over my cluster after a windows update and i'm not sure if that's what threw my server's off or something else. But here's the situation. I currently have the cluster group running on node ...more >>

We are in the process of replacing our current san space with another. In order to do so, we will need to relocate the system dbs from one volume to another. What would be the best way to do so? Thank You, -A ...more >>

Hi, Can I install SQL Server 2005 named instance on the same virtual server as SQL Server 2000 default instance (on Win200 and Win2003)? Thanks ...more >>

Is there any online resources or whitepapers concerning perfmance and physical file location or other IO issues with using SQL Server and a Shark ? ...more >>