|
Home > Archive > MS SQL Server > November 2006 > missing hd partition
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
missing hd partition
|
|
| maverick 2006-11-09, 7:13 pm |
| hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
backup. on backup when i do EM backup and click on the "add" device i
could view the different hard disk partitions of my server (C:, D:, E:,
F:). but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?
| |
| Tracy McKibben 2006-11-09, 7:13 pm |
| maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F:). but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| maverick 2006-11-09, 7:13 pm |
|
Tracy McKibben wrote:
>
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!
|
|
|
|
|