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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-03 : 07:43:01
|
| Richard writes "I have a requirement to backup to a remote machine. I would like to take advantage of the various Database Maintenance Plan features (integrity checking, scheduling, retention periods, etc.) but the I cannot get a UNC to work. I have been getting the following error:Operating system error = 5(Access is denied.).Security on the remote machine is full control to everyone. My question is simply, can you use UNC's in the Database Maintenance Plan's "Use this directory" text box?This is all taking place on SQL Server 7.Thanks,Richard" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-03 : 17:25:55
|
| I believe you can. Remember that it will be running under the SQL Service account (assuming the job is owned by a sysadmin) so if you log into the server as the service account and issue a net use \\uncpath_to_backup_share do you also get access denied ? Is your service account a domain user account ?HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
 |
|
|
|
|
|
Maintenance Plans with UNC's