Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
D3n50n
Starting Member
1 Post |
 Posted - 2005-03-04 : 06:47:34
|
| I'm attempting to save backup reports to a mapped drive in SQL 2000. The drive is visible in Windows Explorer but is not visible when I try to browse to a location to save the reports to in the maintenance plan wizard. Another instance of SQL on another server can see network mapped drives. Is this a known issue? Is there a fix? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-04 : 07:50:28
|
I would stay away from using mapped drives for this, becuse they can become unmapped.You could just save the backup reports via a UNC name instead of a mapped drive:\\server\share\dirThe UNC name will work OK as long as the account that the SQL Server Agent is running under has access to the share.quote:
Originally posted by D3n50n
I'm attempting to save backup reports to a mapped drive in SQL 2000. The drive is visible in Windows Explorer but is not visible when I try to browse to a location to save the reports to in the maintenance plan wizard. Another instance of SQL on another server can see network mapped drives. Is this a known issue? Is there a fix?
CODO ERGO SUM |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-07 : 16:48:21
|
| This looks like an access/ID issue, review your permissions.I Love Challenges! That's why I love coding! |
|
|
|
|
|
|
Mapped drives not visible in reporting wizard