October 12, 2009 at 10:51 am
Hi All,
I haven't a clue when it comes to WIN2003 server administration and I have very little knowledge in SQL administration. The problem I have is that our server administrator has added 3 new hard drives(SAN I believe) to our server. We copied a mdf file over to one of the new drives and tried to attach the database, but SQL does not even have the new drives in its "Locate Database Files - SERVERNAME" browser.
How can I get SQL to recognize these new drives :unsure:
Thanks in advance
William
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
October 12, 2009 at 11:08 am
Assuming that this is a clustered SQL Server....
The drives have to be added as a dependency to SQL. This is done in cluster administration.
Ask the server admin (assuming he knows about clustering) to go into cluster admin, take the SQL resource offline (means taking the SQL service down) and add the drives as dependencies to the SQL Server resource.
Once this is done and the SQL resource brought back online, you'll be able to access the drives from SQL.
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
October 12, 2009 at 11:14 am
Thanks Gail, worked like a charm 😀
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply