I want to configure the best choise to mark this setting to SQL 2005 Failover Cluster, with 64 processor and 128 GB ram: affinity I/O mask affinity mask affinity64 I/O mask affinity64 mask All choise I've done, this message appear, change the id: The time stamp counter of CPU on schedule...more >>

Anyone aware of problems with clustering on sql2005 SE? Pros/cons?...more >>

for some reason the SQL Reporting service didnt get installed on one of my nodes... so i was simply just going to install it... apparently it isnt so simple. how do i go about adding the reporting services to a node? Thanks Justin ...more >>

Im working on sql consolidation project and I am about to build multiinstance 2 node cluster. If I want Integration services installed should I manually install on both nodes or thats something that will be installed automatically on both nodes ( It is crutial to have IS installed) i want ...more >>

Hi, I just setup a SQL 2000 SP4 Cluster test bed. After the SP4 installation, it asked me to restart the system. since it is a cluster, I wanted to find out what is the best way to restart the cluster. Do I need to restart just the node I installed the SP4 on or the whole cluster. Also, as ...more >>

Hello there I've got offical microsoft document about installing and using sql failover clustering. In the offical document i've seen that i need to install MS-DTC on the main node. and the other nodes will recive it automaticly when they will need it. For what the MS-DTC is being used ...more >>

Hello there From some offical documentation about sql server failover clustering i've understand that sql service manager do checkes of IsAlive on each node. On which mechine it exist on. And do i install virtual server on the nodes and not sql server? and where do i install sql server...more >>

Can multiple IP addresses be assigned to a cluster and/or virtual name? I have a 2-node Active/Passive cluster on a switched (not routed) network. Each node has 3 NICs, each on its own subnet; a) public/client access - 192.168.10.0 b) private/cluster traffic - 10.0.0.0 c) data bac...more >>

Doesn't appear to be a site for backups so I'll post here: We're using EMC Timefinder SIM backups with SQL 2000. Anyone out there have experience with these? We're having an issue and EMC' hasn't been able to help. ...more >>

Hello there If i set ewo nodes for sql server failover clustering, where does the database is located? ...more >>

Hello there For my knowlage to implement sql server failover clustering i need at least 2 servers: one as primary node. and second as secondery node But in all diagrams i've seen Shered database. What is it? another server? ...more >>

We would like to upgrade our SQL 2000 clusters to multi-node using Windows Server 2003 (currently a Win2k3 2 node cluster). Does SQL 2000 support up to 8 nodes in a cluster? I know about the 16 instance limit but what about a node limit? Since SQL 2000 came out before Windows 2003 I'm think...more >>

I am getting ready to install a new cluster and was wondering what the best cumulative update would be. I am installing it on a HP 460c blade server and using the x64 version of SQL2005 Enterprise. Any help is appreciated. ...more >>

I am having a problem connecting to my SQL 2005 named instance on a clustered server in another domaim. If I am within the domain everything works fine. If I am in a different domain, I cannot register it through SQL Management Studio or create an ODBC connection. I can ping it and all of the ...more >>

Hi, We have a 2 node, active-active, 2 instance, 64 bit SQL 2005 Enterprise Cluster. When you open the SQL Configuration Manager on either server, you will find entries for both the 32 bit SQL Native Client, as well as the standard one (64 bit) I've read the KB936491 article located at:...more >>

Hello there If i set server as failover clustering can i use simple recovery model? ...more >>

I need to find a document to give to an architecture person on the following questions: What is the best practice for varying service packs on mutliple instances of SQL Server 2000 on the same machine? What is the best practice for varying service packs of multiple instance of SQL Server...more >>

This is a two node cluster running 64-bit wk3 os and sql 2k5 64-bit. Everything works ok except SQL cannot "see" the drives. There are log files that SQL wrote to one of the drives but, when I try to locate the drives from Studio Manager, it does not find them. When I try to create a datab...more >>

I have been trying with no success to start my SQL Server in single user mode and login. Here's the scenario: I've got a one node cluster with SQL Server 2000 installed. I changed the startup parameters of SQL Server to reflect the following: -c -f -m I have disabled SQL Server Age...more >>

Good day to all of you SQL/Cluster GURU's I recently asked a question reagrding a Windows 2003 Enterprise/SQL 2005 Standard 2 node cluster I have, I want to replace the nodes one at a time without destroying the cluster. My initial question was could I add a third node and then when it seem...more >>

Hi all, As an SQL DB Administrator, do you have any checklist which can be done in daily/weekly/monthly basis for operational continuity. Such as, verifying backups, shrinking transaction logs, re-indexing with DBCC commands. Thanks, Koray Ersin ...more >>

Hi All, We are currently working on setting up a 2-Node cluster using SQL Server 2005. Hardware : HP Blade servers : BL 460c (c7000 enclosure) SAN from Compellent Technologies Fiber channel network. OS : Windows Server 2003. My underst...more >>

We have xSeries 460(x3950-8878) IBM Machine , mounted at win2003 and sql 2005 64-bits. At future processes, this machine will take over all distributed database with many application. The failover clauster is configured with Active/Active node and I read about reconfigure processor and I/O Affi...more >>

I have a big client that made the following big mistake: They had a two node Active/Active cluster. They evicted node B. A little later, since they have several similar clusters setup, they also evicted node A from the same cluster and now the whole environment is down. Is there a quick wa...more >>

Hi all, may be a simple question to some of you. I have an Active/Passive Windows 2003 service pack 2 / SQL 2005 cluster configuration. I was just wondering what is the best way of performing windows updates from M/Soft. Is it as simple as just updating the active one first then ...more >>

We are planning the following setup as part of our Business Continuity Planning. We have an active passive cluster in the production and we will also have the same setup in the DR setup. But the issue is that we need to keep the same SQL virtual name in both Production and DR. So in this sce...more >>

two nodes, active/active cluster, SQL 2000 built on Windows 2003. Why so many dbs show offline and how to bring them back???? Thanks so much for your help. ...more >>

Hello there can one server be passive server of two diffrent failover clustereds? ...more >>

Hi all, Please help.We are installing SQL2000 Ent in a 2 node W2K3 cluster and it gets pass "Setup has enough information ... and start copying files". After this it starts copying and stops with an error "Setup failed to perform required operations on the cluster nodes". I also tried install...more >>

Good day SQL /Cluster GURU's My question is a general one. I currently have a basic two node SQL cluster one active/one passive running Sql 2005 standard and windows 2003 server enterprise. what I want to do is rebuild the two nodes, by first adding a third node and then eviciting one of the...more >>

Anyone using SAN based replication care to share a rough pricing estimate for the solution ? ...more >>

If we have our databases tied to a SAN, why would I consider SAN based replication vs database mirrroring as a Disaster Recovery solution? Database Mirroring is free and could accomplish protecting our data and want to know why would i even think of SAN based replication from EMC or Hitachi ...more >>

I have two node SQL 2005 Cluster on Windows 2003 SP1. Now, I have to change both IP address and subnet Windows Cluster servers. is it possible? or What can I do step-by-step? thanks...more >>

I am new to SQL server, I would appreciate any help on following question. I tried researching and found few options (detailed below after the question) which didn't really help what I am trying to do. Any suggestion for the Gurus will be helpful. I am trying to implement a high availabilit...more >>

Has anyone rebuilt system databases for a SQL2005 clustered instance? I have followed the code from "To rebuild system databases for a clustered." section at http://msdn2.microsoft.com/en-us/library/ms144259.aspx, and keep getting message saying to add more parameters. I added the paramet...more >>

As you set up disaster recovery(DR)of your existing production data say in DataCenter 1 to your DR site that may on the other side of the continent, how do you move all the data acorss the first time? It may be Terrabytes of data or for that matter even 100s of GBs. It takes so long to move th...more >>

Hi, we have a 2 node cluster running Server 2003 with a single instance of SQL 2005. We are looking to migrate as many apps as possible to SQL 2005, but will likely need to keep a SQL2000 instance. In addition, we want to isolate some of the SQL databases that are web accessible and will set...more >>

Hi, I am trying to expanding MSDB under SSIS and getting following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microso...more >>

When I install SQL 2005 failover setup, it show the error message " There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. The service cannot be started, either because it is disabled or because it has no enab...more >>

Guys, Can anybody describe me the procedure of restoring master database on a 2005 cluster? I stopped all the services that may logon into the server, but still get the nasty error message: "Login failed for user 'MyDomain\blah'. Reason: Server is in single user mode. Only one administrat...more >>

Greetings all...Thanks in advance... I am so NEW to clustering, I really don't know if I'm asking right question(s) or not...I have been reading enough to be dangerous...I am starting to become familar with terms but that's about it...So, I apologize if I commit any faux paus... I am run...more >>

Hello All Guru's, Does anyone have experience building a Windows 2003 Cluster running two instances of SQL Server 2005 in an ACTIVE/ACTIVE scenario making use of mount points? We are building a SHARE POINT environment (INST1) and a data warehouse (INST2). Because of the drive letter limitat...more >>