March 4, 2010 at 10:42 am
Friends, I have 4 HD (C,D,F,G) units in my server, I only see 3(C,F,G) when i try to restore a database in the server with SQL SERVER 2008.
I can see all the units for windows explorer, but i can't for SQL SERVER. Why is that?.
March 4, 2010 at 10:53 am
Clustered?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2010 at 10:59 am
Respectfully,
In order to be provided with assistance you should provided more detailed information about your problem.
I'm not going to plagurize anyone else but if you search this site you will gain insight on to how to post your question.
Regards,
WC
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 4, 2010 at 11:03 am
I'm sorry Gail.
When I posted my reply your response was not active.
I would have not have responded if I had observed your post...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 4, 2010 at 11:22 am
Yes the server is clustered.
March 5, 2010 at 2:25 am
as far as i know, you need to check the cluster configurations
your HDD should be added into the resource group and all the nodes should have ownership for the HDD.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
March 5, 2010 at 3:55 am
In that case the drives are not visible because they are not dependencies of the SLQ service (set up in cluster admin). For a clustered SQL server to see a drive it must be a shared drive (visible to both nodes), must be configured as a resource in cluster admin and must be a dependency of the SQL Server group.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2010 at 5:59 am
Gail,
btw, that was an awesome catch on the cluster.
You are exceptional and you amaze me. You are a great asset to this forum.
But I guess that I should tell you something that you do not already know. 🙂
Regards,
Welsh AKA "Dick" Corgi
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 5, 2010 at 6:16 am
Welsh Corgi (3/5/2010)
Gail,btw, that was an awesome catch on the cluster.
Not really. It's just about the only reason why SQL wouldn't see a drive that windows can.
I did a clustering project late last year where I was working directly with cluster admin, cluster resources and resource dependencies.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 5, 2010 at 6:29 am
Regardless, you have exceptional skills and I respect you very much!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 10, 2010 at 6:59 am
Thanks for the answer.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply