I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
physical drive divided into 5 partitions. When I choose to backup or restore
I can only see C and E partitions but not the D partition. All three are
NTFS partitions.
Thanks in advance.
JohnI found the problem, but don't understand why. The D partition did not have
the Everyone group define to read the drive, however other groups as well as
myself specifically have rights to it. Why does the group Everyone need to
have read in order to see it?
"John" wrote:
> I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
> physical drive divided into 5 partitions. When I choose to backup or restore
> I can only see C and E partitions but not the D partition. All three are
> NTFS partitions.
> Thanks in advance.
> John|||John wrote:
> I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
> physical drive divided into 5 partitions. When I choose to backup or restore
> I can only see C and E partitions but not the D partition. All three are
> NTFS partitions.
> Thanks in advance.
> John
Probably a permissions issue. What happens if you use the BACKUP
DATABASE command to send a backup to that volume?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||John wrote:
> I found the problem, but don't understand why. The D partition did not have
> the Everyone group define to read the drive, however other groups as well as
> myself specifically have rights to it. Why does the group Everyone need to
> have read in order to see it?
>
When you run a backup, it's going to be run within the context of the
user that SQL Server is running under, NOT your personal login. Check
the service account for the SQL Server service, if that user doesn't
have rights to see the D: partition, then it's not going to show up in
your GUI.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Playing some more and comparing to a collegues setup, it appers to be the
local group system was missing.
Thanks so much for the quick responses.
"Tracy McKibben" wrote:
> John wrote:
> > I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
> > physical drive divided into 5 partitions. When I choose to backup or restore
> > I can only see C and E partitions but not the D partition. All three are
> > NTFS partitions.
> >
> > Thanks in advance.
> > John
> Probably a permissions issue. What happens if you use the BACKUP
> DATABASE command to send a backup to that volume?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
No comments:
Post a Comment