October 16, 2003 at 4:53 am
Shouldn't the correct answer be
The Account that runs the SQL "Agent" service does not have access to that share.
instead of
The Account that runs the SQL "Server" service does not have access to that share.
??
Larry Ansley
Atlanta, GA
Larry Ansley
Atlanta, GA
October 16, 2003 at 5:34 am
No, for two reasons:
1. the question was about creating a backup by executing the BACKUP statement manually - not as an SQL Server Agent job. You don't need the Agent to create backups.
2. for network access, the SQL Server service always uses the account with which it is logged on to the system. So, if you send a BACKUP command, not your account is used to access the target share but the service's account. You just need backup permissions to do so.
You can find more information in the SQL Server Books Online, chapter BACKUP (Description)
October 16, 2003 at 6:11 am
I think this question is somewhat ambiguous, as the error also happens often and somewhat randomly.
We have chased this error over a year or so. It appears in a lot of news group postings as well, many are simply account problems, but there is also some kind of issue that many people have which causes this to work one time, then fail the next.
I'm wondering if anyone else has been having that experience.
PS. I've never seen it on small backups, it is always huge multi-gigabyte backups that might run for a LONG time, and the errors often occur during the run. we've had it on a switched 100mbs backbone with dual NIC's in each box, the network never shows a blib, but the error occurs and your backup dies.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply