.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server does not detect new clustered SAN Drive

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server

I just joined this organization as a SQL Developer/DBA and manage some of the servers there. One of the applications has a dedicated Win 2003 server for Production running SQL Server 2005 on an Active/Passive Cluster. We requested the storage team for a new SAN Drive be included to the existing cluster so that the daily backups be routed to that Drive (G:) allowing the application enough space on the Data Drive (E:).

The storage team successfully assigned the new SAN Drive to both the clusters after a re-scan. The new drive was available to the OS either to the Active Node (Node 1) or to the Passive Node (Node 2) after failover. But somehow, SQL Server does not recognize this drive as part of its resources and so I am not able to route my backups to the new drive (G :).

Below are the configurations of the cluster.

The server has three Groups in Cluster Administrator as Cluster Group. Group 0 and Group 1.

View Complete Post

More Related Resource Links

Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1




In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.


Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.


But I am able to start the SQL Server successfully from command line (without any flags).


When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .


Please let me know incase you need any more information.

Detect if code is running inside SQL Server.

Can managed code "detect" if it is running in the normal .Net CLR or the special SQL Server CLR? Is there some environment flag or field we can look at at runtime? Thanks Cap'n  

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

how to detect a located server

hi guys, I need your help. I did a little research to find a source that would check the proxy server whether if the server is a located at government or fbi's server, but I couldn't find it. Any info would be much appreciate. Thanks, Mark

SQL Server Specs of Hard Drive

Hi, Is there a SQL Server script that gives information about a hard drive, like the size of the Hard Drive, Free space and how much of the hard drive is used?

Oracle clustered table to MS SQL Server 05 SSIS

Hi Guys, Can the SSIS deal with clustered Oracle tables? Moreoever, what are clustered tables compared to partitioned tables? I cant find much about it. (only sytax how to create them). Thanks, metalray

The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. S

Hello, I have a node of 2 servers of Win 2008 R2 Enterprise and trying to install a 2nd instance in a SQL 2008 R2 Cluster. I had SQL_INSTANCE2 previously installed that I removed from the two nodes. Now when I attempt to install it again from scratch, in setup GUI where I specify the SQL Server Network Name and enter the previously entered name "Server02", I get a failure in the setup with the following error message: "The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. Specify a different failover cluster instance name." How do I fix this problem, I don't want to enter a new name like "Server03" in order to proceed with the setup, because when I do enter "Server03" the setup does continue without an error message. So what am I missing? Do I have to ask the DNS administrator to see if there's an A record for "Server03" and have him delete it so that the setup works? Or the fix is by doing something else? I would appreciate any help. Thank you  

Can't remove instance from clustered server

Hi ,

I'm using SQL Server 2008 and I have on Active-Active Cluster on
a Windows Server2008.

I have one SQL instance on that Server. The other node I had SSAs wich I want to uninstall and be with another instance of SQL.
I had SSIS has a clsutered here also.

I unistalled the SSAS and made Prepare SQL to Cluster intallation on Node 1 (that already had one SQL instance).

When I tried to Complete the SQL Failover clustered installation I cannot reach the instance and after a few atteps I cannot connect with SSIS on this clustered.

I cannot remove the SQL instance from ADD/Remove Programs because it gives me the error that this instance is used has a cluster.

So this is what I want to do:

-Remove the instancethat says that is clustered but I can't see the cluster on Failover Clustered Administration.
-Setup SSIS as a clustered service on the instance that was previous installed(I can reach the SSIS editing SQL Agent Job but I can't connect through Database Engine.Through the Agent all the packages are unreacheable but visible.)

I already See that I can't add features to a clustered installation but I read that it's possible to Add SSis if I stop both nodes. How can I stop both nodes to install SSIS.

SQL2008 cannot detect clustered disk


I've created a sql2008 sql cluster on windows2008 with all the latest service pack when i add a new clustered disk recently; it can be added to the sql cluster but the SQL management studio cannot "see" the newly added clustered disk.

Any advise?

Thanks for any info

Changing Clustered SQL Server 2005 Default Server Collation


We are attempting to change the default collation of an SQL Server 2005 Clustered environment. We have created an "unattended install" script to perform this, and have modified it several times as errors have arisen repeatedly. The last time, however, we used the following script:


We are running this script from the primary (Active) node of the cluster. We did notice that the bootstrap logs created from this final execution did include logs from both nodes. When I look in the Summary.txt file, it tells me that Setup succeeded with the installation. After the script executed, we rolled the cluster from primary to secondary, and rebooted the primary node. We then rolled the cluster back to the primary, and rebooted the secondary node. Once that was complete, we cycled the SQL Server service from the SQL Configuration Manager. After all those steps, we opened SSMS client to look at the properties of master, and the collation was still CI_AI.

We are losing valuable time in

SQl server 2008 installation is a different drive


1. Can I isntall sql server 2008 is different drive other than C. What is the best practice.

2. Due to a corrupted DB my SQl server generated huge log files and dump files that my C drive ran out of space. So is there an option in the maintenance plan to clean up SQL error log file which is located in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log .




WMI Event Watcher on a Clustered SQL Server


I have an SSIS package that uses the WMI Event Watcher task to watch the file system for a file to be dropped into a directory. When the file is dropped in the package processes that file.

This all worked well in dev and test. But when I move to production I have a problem. My produciton server is a cluster. I am attempting to watch a directory on a cluster drive. However, I am unable to get events triggered off that drive. THere are no errors the package starts up OK but when I drop a file into the watch directory nothing happens. If I configure the package to watch the C drive it works fine. So I am pretty sure something is different when watching a cluster drive.

The server is SQL 2008 on Windows Server 2008 R2 64-bit.

Here is my connection: \\servername Namespace: \root\cimv2

Here is my query: SELECT * FROM __instancecreationevent WITHIN 10 WHERE TargetInstance ISA 'Cim_DirectoryContainsFile' AND TargetInstance.GroupComponent='Win32_Directory.Name=V:\\\\FileTransfer'

Does anyone know what I should be doing differently?

Thanks in advance.

Adding Instance(SQL Server 2008 R2) and Moving Quorum Drive


Hi all,

I am Planning to Add new SQl Server 2008R2 Instance to SQL Server 2000 SP4 in Windows 2003 SP2 OS and As of now all the storage in SAN drive

Here problem is my company is going to move SAN drive to iSCSI and they given me iSCSI drives to Install SQL Server 2008R2 and they ask me Create Quorum drive on iSCSI.

1. Is it possible to create one more  Quorum  Drive or I need to move excisting Quorum to new Drive

I have below Groups in SAN Drive and I want Move those groups to iSCSI Drives what is best way ..to do this  with minimum Down time.

Cluster Group
Cluster Ip Adress
Cluster Name
MSDTC NetworkName

Disk G:
Disk L
SQL Server Name
SQL Server Agent
SQL Server Fulltext



Thanks in Advance



Changing the SQL Port of a Clustered SQL Server 2008 in Win Server 2008R2



The above setup is in vmware. The 2-node cluster works fine. Able to failover to and fro.  Just that when I tried to change the port 1433 to 12345, the cluster is not able to online the SQL Service. Below is the application error log:

[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 274d; message = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

The service status becomes Pending Online and after a while, it becomes offline. Using the SQL Configuration Manager, I revert to 1433 and it works fine again. May I know what am I missing ?





Copying SharePoint databases from single SQL server to clustered SQL servers, is it possible?



I am going to install SharePoint on load balancing servers - two front web servers, clustered database and on query server.

Since ordering the required hardware for clustering may take long time, my company decides to install SharePoint databases on single SQL server, and later on the databases will be restored on the clustered database server, any SharePoint configuration related to database will use DNS name not the IP address.

My question , in order to copy SharePoint database from single SQL server to clustered SQL servers ,Can we take backup from SharePoint databases (Content , Shared services ,Search …) from single  SQL server to be restored later on clustered SQL server? And then change DNS record to refer to the clustered IP address without any modification on SharePoint settings?



Clustered SQL 2008 R2 x64, Oracle linked server works on one node, fails on the other


Juicy bits:

- SQL Server 2008 R2 x64

- Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) 

- Active/passive cluster

- Oracle client 11gR1

- "Allow Inprocess" provider option is enabled


I'm stumped.  Our development, QA and UAT environments are all running the same versions of Windows, SQL, and Oracle client.  Linked server between SQL and Oracle works just fine.


Production is clustered.  The linked server works just fine on one node of the cluster, but if we failover to the other node, attempts to use the linked server in any way, OPENQUERY, GUI, etc..., cause the following error:

OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE" returned message "ORA-12634: Memory allocation failed".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE".


What am I missing?  I've reinstalled the Oracle client on the defective node, verified that the SQL Server service account has full rights to the Oracle client dir

Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e



I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend