September 4, 2006 at 6:23 pm
My development server has 2 hd's (C: and D. I keep the data and log files in D. I found out today that SQL is not able to see (so to speak) that there is a D hd. I f I go to MyPC, I can perfectly open the D hd and verify that the data files are there. Can anyone shed some light to this?
Thanks
September 4, 2006 at 8:31 pm
Was it ever able to see D?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 4, 2006 at 9:13 pm
Hi Jeff. Thanks a lot for responding. The answer is "yes": the original data files for most of the data bases in the server get built there.
After I posted the message in this forum,knowing that someone would help me, I was able to think better and looked at this from the stand point of share permissions for the hard disk, since a couple of the databases were ok and they hat the data and log files built in C rather than D.
I found that, while doing some housekeeping in a hurry (never again), I deleted a "System" User Group from the hard disk Security Properties. When I restore it..SQL saw the light again!
I appreciate your interest in helping me. Hopefully this situation can be helpful to somebody else.
Regards
September 4, 2006 at 9:46 pm
Outstanding, Ray... that was the next thing I was going to ask... who changed what? You beat me to it. And, thank you very much for the feedback... you'd be amazed at how many people something like your post helps people. They don't usually post a response to say "thanks" but I did do a "hit" count on another forum I'm involved with on something similar... over 8,000 hits in only 2 years...
Thanks again for the info on what you did!
--Jeff Moden
Change is inevitable... Change for the better is not.
September 8, 2006 at 1:37 pm
No, thank you for taking the time to try helping users like me.
Have a good weekend!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply