is there a diffrence in the hardware needs of the machine if i setting up a cluster?...more >>

Hi Everyone, I'm looking to put together a cost for building a SQL 2005 cluster with the database running off an HP storageworks SAN or array. At this stage I really just want to get a rough cost for the lot, so I am looking at components, storageworks hardware and software required. Has...more >>

My employer is asking to do an Active / Active SQL 2000 cluster to utilize both servers. Problem is, I don't think SQL 2000 supports an Active/Active solution because both would need access to the disk which isn't possible... The only time an Active / Active cluster can work is when you have...more >>

Install worked fine, installed sp4 but when I go to fail from one node to the other it fails to start on the second node. All shared storage, IP's failover correctly, node service accounts are the same, second node can connect to the instance by name when it is started on the other instance. If ...more >>

I have been "tapped" to install a passive node on an instance of SQL that is not currently configured for clustering on a W2003. Can I simply install clustering services on the current production instance, then install a new instance on what would be the passive node? Then add it via cluster adm...more >>

I have a Win2003, SQL 2005 active/passive cluster. We did a fresh install of the OS and SQL. The install of SQL seemed to go OK. I installed SP1 with both nodes active. The install went successful on the active node (Node A), but SP1 was not installed on the inactive node (Node B). I installed...more >>

SQL Server 2000 running nothing but a 300MB database over the course of a month of continuous use from a single application winds up grabbing 1.4GB of RAM. Is that normal or excessive? (No performance degradation at all, jut a lot of RAM allocated.) This is clustered, but the problem has o...more >>

If you run SQL Server 2005 Standard Edition in compliant mode 80, can you still utilize log shipping, database mirroring, or clustering? If it is possible, are there any problems related to the setup or administration?...more >>

Hi, I'm writing a proposal for a DR solution for a SQL based application. I've been looking at clustering, database mirroring, etc. Has anyone come across any documentation discussing the pro's and cons of the various options available? Thanks ...more >>

From a "price point of view" migrating from the actual platform (2 node cluster Windows server 2003 with SQL Server 2000 Enterprise Edition)to MySQL can be very attractive. In fact our management starts to think that way... My question is related to the faisability of this operation in a criti...more >>

Overview: We are planning a 2 node cluster. The Active node will be 8 GB RAM with one instance of SQL 2005 and 150 GB of SAN disk. This is considered the production node with failover to the second node (Passive). The passive node also has 8 GB of RAM, 150 GB of SAN disk, and has 4 local...more >>

I am pretty sure the answer is Yes, but I need to cover my bases on this. I know the SQL is covered, but are the applications above capable of functioning, i.e. cluster aware, in a clustered environment? If so, does anyone have any instructions or pointers to set me off into the right dire...more >>

How can I restore master (SQL Server 2005) database on cluster environment? Thanks in Advance....more >>

Installing SQl2005 into on Win2003 2 node cluster, at the very end of the setup receive a message 'Remote Setup failed'. Referred to some sql logs and found this; Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:\Pro...more >>

Hello, We are seeing a very bizarre occurence in the config mgr. I have a win2k3/sql2k5 2-node, single instance cluster. When we look in the config mgr., the SQL VIP is not present. I have IPs for the the "passive node," the Cluster VIP, the heartbeat IP, and the loopback IP. However, t...more >>

Hi all I've got a sql 2005 active/passive cluster on win2k3 servers. In cluster admin under sql server 2005 group resources i've got: 3 physical disks IP Address - ip address of mycluster server Network Name - mycluster-depends on Ip address SQL Server - sql server - depends on ...more >>

Hi all, I have a issue when i tried to copy database from a machine with MSDE database to a new sql 2005 cluster server. I could not copy it with copy database wizard. Here is the message i got. TITLE: Copy Database Wizard ------------------------------ The action you attempted...more >>

If you want to deploy a SQL 2005 geocluster or a cluster without shared storage for quorum - there is only Windows 2003 Ent Edition "Majority Node Set" option. Majority Node Set implies three nodes for failover - in case one node is failing. But I have 2 SQL 2005 nodes and no shared storag...more >>

Has anyone successfully created a test setup with Virtual Server 2005 RC2 using two shared resources: Quorum and Shared Disk Array. I have followed the "Using MicroSoft Virtual Server 2005 to Create and Configure a Two-Node Microsoft Window Server 2003 Cluster" document and everything works fi...more >>

Hi all, I backed up a database called Citrix_DB through Enterprise Manager from = a standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000 = Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. = And below is the error message: - Microsoft SQL-DMO (ODBC S...more >>

Hi, I am looking for a SQL 2000 installation documention on a clustered network. Online links/documentation is preferred than books. Thanks, Mehul...more >>

Hi, I am deploying a SQL on a three node active cluster setup. Each node will have a SQL instance running in the cluster virtual server context. This is the baseline setup required for deploying application databases on the three SQL instances. Application databases are deployed using an MSI ...more >>

I am trying to create a database but it failes when creating the log file. Q:\ quorum drive H:\data I:\log The message I get on the I:\ Cannot use file 'I:\Log\rentclicks_Log.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency ...more >>

I read that you can implement DB mirror in a cluster. However, someone else said that you cannot. Does anyone have any ideas which is correct?...more >>

We are attempting to setup Integration Services on a Cluster per the following article: http://msdn2.microsoft.com/en-us/library/ms345193.aspx We have the following Cluster Groups/resources "Cluster Group" Disk Q - Quorum Disk R - MSDTC MSDTC MSDTC IP Address Cluster Name Cluster IP ...more >>

Hi all, We have many databases to manage and my question is related to T-Log backup. At the moment we take t-log backup every 1 hour but on different time for each database. For exaample for db1 we take t-log backup at 7.01 AM every hour until 19.01 PM and for db2 we take backup at 7.05 AM ...more >>

Hi Everybody, Is it possible to configure one virtual SQL server named instance to listen on multi IP Address those additional IP Addresses associate with different virtual SQL network name? At the result like for example: SQL Server 2005 EE installed on (Windows 2003 64 bit OS cluster s...more >>

what accounts are required for SQL cluster setup? I was trying to install SQL Server and ran into some prompts that I did not see in the books that I read about SQL cluster setup. I know about SQLservice account. However, I didn't know it requires a domain group for each service, SQL Serve...more >>

We are planning to have our IPs restructured on our disaster recovery site (DR) because of some business policies and requirements. We are running an active-passive SQL Server 2000 Cluster environment on both sites. I am running log shipping on this particular environment. Is there anything...more >>

Hi All, We have a 2 node cluster running SQL Server 2000 on Windows 2000 which needs replacing. The nature of our business is 24 hour operation, so the downtime to do such needs to be as small as possible. We have a new cluster ready and waiting in our data centre that is built on Windows 2...more >>

I am trying to run a VBScript that uses a SQL user to access a 2000 SQL SP4 clustered instance. The script runs successfully only when I am logged on with a domain account. What can the reason for this be? Thanks in advance, Ido Friedman...more >>

Hi, when i setup mirroring between two databases, how does failover happen at the client. if i setup a principal, a mirror and a witness, how does the client redirect it self to the mirror server automatically? would appreciate if someone could point me in the right direction. regards...more >>

I had the opportunity to attend a Windows 2003 Clustering Class offered by Rod (and Russ) in NYC. In my eleven years of IT, I have attended 8 or so classes. This was the best class I have ever attended - period! The way that Rod and Russ have designed this course, I wish MSL (Microsoft Learn...more >>

I have a SharePoint installation that currently uses a single SQL Server and connects to the default instance. I want to migrate to a cluster without doing a full backup/move/restore. I'm thinking if I set up the cluster with the same name as the current SQL server it should be transparent to ...more >>

I've installed sql server 2005active/passive cluster on Win 2003 Ent Edition boxes connected to 3 SAN drives L, M, S. When setup asked me where to install datafiles i choose the S drive. SP1 installed, everything looks good, failover succesfully both ways. However in SQL Server Managment Studi...more >>

...more >>

Hi, We have 2 blade servers and we need a clustering solution which will run win2k3 and SQL 2005 in an Active/Passive mode. The catch is that our SAN will not be in for another 5 weeks. The business needs to go live so I am trying to find out what is the best way to handle this. I am thinki...more >>

I am going to setup 3 set of SQL Server clustering, the 3 servers will be direct attached via 4Gb FC cables to SAN storage (15X 73GB disks, FC 15K RPM). Each server has the following configuration: OS: Win2003 Enterprise 2X Dual Core Xeon 3GHz, 1333MHz FSB, 4MB cache 16GB, 667MHz Dual Ranked...more >>

I have two SQL 2000 Virtual Servers running on a windows 2003 cluster. They each have a data and a logs drive configured (located on a shared SAN). The Windows virtual servers can see both drives just fine. But in SQL when I try to changle the location of the Logs directory I am only offered ...more >>

So per MS "Run the SP1 executable package file from the node (active node) that owns the group containing the virtual server that you plan to upgrade." What does this mean? We have an active passive cluster with the following names; BPDB1 - Active node - Owner BPDB2 - Passive node - Owner...more >>

Trying to install a second named instance of SQL Server 2005 on a Windows Server 2003 Enterprise two node cluster. I am installing on the node which the cluster group is currently on. The first named instance I installed went in like a champ - I have a Cluster Resource group, a SQL Server(...more >>

Hi I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server. I would like to install a local copy of SQL Server on the node that is currently passive - if I start the SQL install process, it does give me this option but I don't know what, if any, problems this might cause. I appre...more >>

We have two sql cluster nodes that works fine till lastweek. i can still move the cluster goup manualy from the one node to the other. the problem is i can't move the sqlgroup manualy to the other node. When i do that the sql manager hangs and nothing happends till i reboot the node where the ...more >>

Hi, I have a database containing 1GB data. I have tuned all of queries and indexes and they perform good comparing with the current hardware. But still we lack performance! My boss has admitted that the server's hardware must be upgraded but its my task to choose and offer the appropriate har...more >>