Cannot see my data files!
-
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
-
Was it ever able to see D?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
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
-
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
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