Error when backing up to a backup server

Question

Error when backing up to a backup server

cstrati

SSChasing Mays

Points: 606
More actions
July 11, 2014 at 12:54 am

#397044

I'm trying to backup my databases to another backup server though I'm receiving the attached error.
the SQL service is logged on as "Network Service"
Please let me know if you can think of a potential cause.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233836 More actions · Answer 1

go onto the remote server and find the backups share. You need to check and set Share permissions then move to the folders security tab and set NTS ACLs too.

The computer account for the sql server must be granted permissions in both these places.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 2

Please check folder rights. It seems folder doesnt have required rights.

Thanks

cstrati SSChasing Mays Points: 606 More actions · Answer 3

The SQL Service account is logged on as "Network Service" instead of a domain network account.

Am I still able to give it permissions to the backup server somehow?

Perry Whittle SSC Guru Points: 233836 More actions · Answer 4

cstrati (7/14/2014)
The SQL Service account is logged on as "Network Service" instead of a domain network account.
Am I still able to give it permissions to the backup server somehow?

Did you read my post above??

The computer account of the sql server must be added to the share\NTFS ACLs on the remote server.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

cstrati SSChasing Mays Points: 606 More actions · Answer 5

Sorry can you please step me through on how to do this?

cstrati SSChasing Mays Points: 606 More actions · Answer 6

The actual SQL Server is running under "Network Service" and is on a different domain so I'm not sure how to give it access the way you mentioned.

Perry Whittle SSC Guru Points: 233836 More actions · Answer 7

cstrati (7/20/2014)
and is on a different domain

You never mentioned this before, complicates things even further. Is there a trust relationship between the 2 domains?

You really should be working with your network admin to get this resolved

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉