I have taken SQL Server resources OFFLINE. Will the SQL Server resources be brought ONLINE automatically during failover or will it be in the OFFLINE state until brought ONLINE manually?...more >>

Hello, I'm just configuring a Database Mirror with SQL 2005 SP2. I have two = SQL-Servers SQL1 and SQL2 and one Whitness. Everything is working fine, = when I plug out the ethernet cable from SQL1 the whitness is detecting = the failure an is switching over to SQL2 and so on. The running = ap...more >>

After installing SQL Server 2005 Cluster (64 bit) on a Windows 2003 EE server, I received the following error listed below when I tried to connect to the Database Engine. Error: you cannot configure surface area of cluster services by connecting to a computer name. Connect to the virtua...more >>

Hi, I got this error when I move the log file to a diff location in the cluster environment. Any ideas and solution? Thanks Msg 5184, Level 16, State 2, Line 1 Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only formatted files on which the cluster resource...more >>

Ok my job is done. I have built a fully tested Windows and SQL active/passive cluster. Not the software guys take over but as an inquiring IT guy I can't call it done withoout some more education. Please feel free to answer these questions or send me to more information please. 1. I un...more >>

I have posted this once before but I cannot find the thread for some reason. I have a client that I am going to be doing some colo hosting for. He has two brand new servers. He has not bought any operating systems as of yet and will also need SQL Server. The only thing these will be used f...more >>

We are currently running SQL Server 2000 Enterprise edition in a two-node active-active cluster. We are looking to upgrade to SQL Server 2005, but I want one instance to be Enterprise Edition and the other to be Standard Edition. My co-DBA believes that there might be a problem running both...more >>

I understand that Microsoft do not support SQL Server 2005 failover clusters where the cluster instances are also domain controllers. Can anyone tell me the reason for this? Is it to do with performance, resilience, or some other reason? Thanks, Andy Johnson ...more >>

Hi All, Getting the last day of the month, for the given date, by TSQL is bit tricky. Following user defined function provides you a handy general purpose function to get the last day of the month. It gets the last day of the month as follows: For example we have a given date 17-March-2007...more >>

A quick rant - After days of study, hours of install, and some killer directions for Brad M McGehee I began to install a SQL Cluster on a Windows 2003 enterprise server cluster. If only i had found that one little article that said that the install fails if you use two Cds. So here I am fo...more >>

Greetings, I've inherited a cluster configuration and I'm new to administration of clusters. 2 node 64 bit SQL running on 64 bit Windows 2003 Enterprise Edition. I'd like to install a new instance to the cluster but do not know the method. My searches have turned up only installing from scrat...more >>

SQL 2000. I was trying to move the system files, I managed to move the master, msdb, tempdb but then it died on the model. and I need to recover database... the sql service keeps failing. thank you!!! ...more >>

Can i set up clustering on a single node only to add the second node later..i.e pending budget approval for second node as an example for holding off on second node for now ? Also if the answer is yes, can you add the second node without taking the current cluster or SQL offline ? Thanks...more >>

Thanks in advance for any help. A SQL 2005 Failover Clustering installation (from the RTM disks) failed on Database Services. Please see messages below. Windows cluster server name is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node = COMDEVCLU02. SQL cluster virtual...more >>

How would I go about installing the second node for SQL 2000 cluster? The first node is up and running. ...more >>

How would I go about moving the system databases to a new drive? e.g. from C: to G:? Thank you! ...more >>

If I need access rights to manage sql services(surface area config) in a cluster server. What kind rughts do I need? local admin? Thanks ...more >>

Hi, Can I install SP2 for SQL2005 one instance. Is this affect other instances in the same cluster server. Thanks ...more >>

Hi I do not have any experience of clustered servers I have some software that needs some dll's placed into the directory below which an extended strored proc uses to verify and run internal code. C:\Program Files\Microsoft SQL Server\MSSQL<instancename>\Binn this works perfect on single...more >>

I inherited a SQL2005 cluster and while I'm experienced in managing SQL stand alone I have no experience in a cluster environment. I am trying to determine the cluster virtual server name, as opposed to instance, so I can make changes to the service start up configurations. I can't get the utilit...more >>

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2 on the active node, all went through successfully, but it dodnt. It left one node SQL SP2 and 1 Node SQL SP1 No every time i install the service pack on the sp1 node i get an error as detailed below. Been on to MS so f...more >>

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2 on the active node, all went through successfully, but it dodnt. It left one node SQL SP2 and 1 Node SQL SP1 No every time i install the service pack on the sp1 node i get an error as detailed below. Been on to MS so f...more >>

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2 on the active node, all went through successfully, but it dodnt. It left one node SQL SP2 and 1 Node SQL SP1 No every time i install the service pack on the sp1 node i get an error as detailed below. Been on to MS so f...more >>

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2 on the active node, all went through successfully, but it dodnt. It left one node SQL SP2 and 1 Node SQL SP1 No every time i install the service pack on the sp1 node i get an error as detailed below. Been on to MS so far,...more >>

What is the maximum disk or SAN time-out a SQL-server cluster can handle? Is this documented anywhere? Regards...more >>

Hello there I have huge sql server databese that works on single server right now. To the database there are at least 6 applications that update the data and use it. as a result of that there are problems on performance. I've heard that by using sql server clustering i can do 3 things ...more >>

Let me know what you think of the product.Is it worth considering than say the MSFT cluster ? Thanks ...more >>

I have to install MSDTC on an Active/Passive cluster. I got instructions from microsoft's website on how to enable MSDTC: http://support.microsoft.com/kb/817064/ but when I follow the instructions, the service never starts. Even when I try to start the service manually I am unsuccessful. ...more >>

I have set up SQL05 Mirroring with a witness server and everything was working fine. We had a memory problem on the primary server, and the mirroring worked, and it failed over to the secondary box as it should have. Our application has the following in the cn string: 'Data Source=sql1;Fai...more >>

I have a scenerio where I must implement a Highly Available environment between two locations seperated by 25 miles. The premise is to create a solution that will keep our application up and running if our main location were hit by a tornado, an auto failover would take place to the remote ...more >>

I have a client that wants me to start hosting their SQL and IIS for them. They want to have the ability to have a "hot spare" in case the primary SQL server fails. I have read and read until my eyes hurt about clustering and mirroring and I am getting more confused on how to proceed. My ...more >>

I have a Active/Passive cluster and have installed the SQL 2005. What I would like to know, before I proceed with my configurations (since it is my first time in a cluster environment) is whether I will need to attach the database (lets call it DBX) to SQL Server on both the servers seperately,...more >>

Hello, I want to remove my backup raid container or x: drive from my sql group because I don't want my sql service to fail as this volume has had some problems with the hard drive firmware on the raid container. I've tried to find out if this is possible to do and have not found anything yet....more >>

I have a two node cluster with SQL Server 2005 that I am having difficulty getting AWE to work. I have granted the "lock pages in memory" right to the domain account that the SQL Server service is running under on both nodes and run the following commands to setup the AWE memory. sp_config...more >>

We have had a 2 node cluster. We added a 3rd and fulltext does not show in EM - Support services. Using sp3a+ms03-031. ...more >>

When I was installing SP2 in a server with Win2003 server then Database Service failed with those messages bellow: Product : Database Services (SQLA) Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File ...more >>

We have a single node cluster using SQL2K EE running on Win2K EE, and this has been running fine for a year or so. We finally have our new data centre completed, and the additional hardware installed for us to install the second node. 1) I installed Cluster services and added the second nod...more >>

Windows 2003 SP1 SQL 2000 SP3a active/passive cluster 24x7 cluster used by customer facing apps. Added a new node to the cluster and failed over. The Full Text Indexes on my database are “gone”. If the resources are owned by the “old” node, I can work with the Full Tex...more >>

Here is what we are trying to accomplish, and please let me know if we are going down the right path. We have 2 Windows 2000 Servers running SQL 2000 for a website. The SQL database is on one of the two servers and we want to create a redundant environment so when one of the SQL servers fail...more >>

Windows 2003 SP1 SQL 2000 SP3a active/passive cluster 24x7 cluster used by customer facing apps. Added a new node to the cluster and failed over. Now my Full Text Indexes on my database are gone. When I run SELECT * FROM dbo.sysfulltextcatalogs I get: ftcatid name status ...more >>

I'm looking for evaluation criteria that will help in rationalizing the total cost of ownnership of the following Database Infrastructure Failover Capability tools and making an informed selection: * Microsoft Cluster Services * Polyserve * DoubleTake * VMWare Thanks for any pointers. ...more >>

Hi, I see that after the AWE hot fix in our production server [Not the standard microsoft recommended MSI way, only the SQLServer.exe and OSQL.exe are replaced] the following are the versions of each component. osql.exe , 2000.80.1025.0, 16-May-2005 6:51:12PM sqlservr.exe , 2000.80.2040...more >>

I am migrating a SQL Instance to an existing SQL 2000 cluster that already has the default instance installed. There is a large user community that will be accessing the databases in the 2nd instance and I am trying to find a way to configure the installation so that they can continue to use ...more >>

I understand how to install SQL 2005 on an active/passive windows cluster. Management has decided that we will be moving to an active/active/active/passive windows cluster. I am looking for information on how to install SQL 2005 clustering on this type of windows cluster? Does anyone know of...more >>

Do I need to install SP2 on both Nodes of the cluster or Just on one node? ...more >>