Network drives not available on Database Maintenance

I am trying to establish a Database Maintenance plan for our SQL server and when I choose
Database Maintenance Plan
Complete Backup Tab
Under choose directory when I choose the (...) icon to choose a directory only the C and D drive of the server appears, I do not see the network drives.
I resolved this in the past but forgot how to.
Thanks
Jeffrey
What I used to do in 6.5 was run a scheduled task that had the ID that SQL was running under to map the network drive. I have not had a need to try this in 2k but it is worth a shot.
Jeff
MCDBA, MCSE+I
|||Not too sure if you can do this on Database Maintenance Plans
Put you can create a Backup device pointing to a Network drive and create
backup jobs to that network device(s)
Regards
J
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks
|||Type in the UNC name of the share. Make sure the SQL server service account
has permissions to that share.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jeffrey Sheldon" <jsheldon@.projecthope.org> wrote in message
news:34DCEFE7-6054-44BB-B6E1-BF1AB9F79CDD@.microsoft.com...
> I am trying to establish a Database Maintenance plan for our SQL server
and when I choose
> Database Maintenance Plan
> Complete Backup Tab
> Under choose directory when I choose the (...) icon to choose a directory
only the C and D drive of the server appears, I do not see the network
drives.
> I resolved this in the past but forgot how to.
> Thanks