April 6, 2010 at 3:49 pm
I've just set up two instances of SQL 2008 and neither one recognizes that there is a 'D' drive on the box.
If I try and change the default file location(s), I can only choose from the 'C' or the external disk, 'X'. The 'D' drive is not a valid choice, not even an option.
The machine is set up RAID 5; Disk 0 = 'C', Disk 1 = 'D', Disk 2 = 'X'
Any help would be greatly appreciated.
Thanks..
April 6, 2010 at 10:57 pm
Is drive D active on the server logical disk manager?
can you browse and copy data to the D drive from windows explorer?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 7, 2010 at 1:18 am
Let us know the answers to Henrico's questions.
Also, is Drive D formatted as NTFS or some other file system?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2010 at 8:20 am
The D drive is the data drive, the C drive holds all programs and system files. Accordingly, we write to it all the time.
The SQL2008 install is new. We have been using SQL2000 and are in the process of upgrading when we ran into this problem.
And yes, it is formatted NTFS .
Thx.
April 7, 2010 at 8:26 am
Oops, forgot...
No, the D drive is not active in Disk Mgr. The C drive is the active drive.
April 7, 2010 at 10:50 am
The D should also be marked active.
Were you also unable to see the drive during SQL 2008 setup?
Somewhat perplexing if you can write to the drive outside of SQL Server. I think it may be related to the drive not being marked active.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2010 at 1:02 pm
I'll have to ask the person who did the actual install whether he could see the drive when the software was loaded.
Also, I'll check out the Active status as well.
Thanks, Jason.
Cheers.
April 7, 2010 at 1:48 pm
You're welcome.
Keep us posted on what you find.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2010 at 3:56 pm
Greetings...
After more searching, web crawling and some hair-pulling, we discovered that our IT Dept had things screwed down so tight on this specific drive on this specific server, the problem turned out to be a permissions issue; imagine that. Someone once told me that over half the problems people have with SQL revolve around security.
Anyway, the Network Service Account was added and viola, there's the D drive.
Can I tell you why SQL 2000 was able to function properly when SQL 2008, couldn't? Nope. All I know is that there must be some big differences between the two in the security department.
Thanks, everyone, for the help.
Cheers.
April 7, 2010 at 4:04 pm
You're welcome
I find that result quite interesting. I am glad you found the solution.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply