November 19, 2015 at 4:07 am
We are running SQL Server 2008 (SP3) [10.0.5520.0 (X64)] on a Windows 2008 server.
Last night, all our backups failed. We eventually tracked it down to a permissions issue in the Backups Folders,
which are on a shared Network Drive.
In our set-up, SQL Server and SQL Server Agent run under the Network Service account.
At some point, the permissions for the Backup folders were changed, and Network Service was excluded
from accessing all the folders in the Backup area, at all levels of the file hierarchy.
I realise that this may have been caused by a process that was nothing to do with SQL Server.
But I would be interested to compare notes with anyone who has seen this kind of behaviour themselves.
November 19, 2015 at 4:21 am
the "System" account should have permissions everywhere accross your infrastructure. If not any service that is using a local service account will fail. Your backups are most likely to fail too at an org level.
I suggest you address this urgently via your network admin team, the person who removed it from the permissions should be put forward for the Darvin candidate of the year award
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply