SQL backup to network drive

Question

SQL backup to network drive

RVO

SSCertifiable

Points: 5495
More actions
November 30, 2012 at 10:02 am

#267523

Our 20 SQL Servers all running under "Local System account".
Backup to network share doesn't work - Error.
I guess because local account doesn't have access to network folder. Even when I add "Everyone" FULL CONTROLL to the folder.
What is the solution?
Does it mean we have to change SQL Server service account to Domain account on all 20 servers?

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

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

TheMaskedDBA SSCrazy Points: 2787 More actions · Answer 1

More likely that you will need to change the SQL Agent service account to a domain account that has access, not the SQL Server service account.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

if using local system you need to allow the machine account access to the network share

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

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

RVO SSCertifiable Points: 5495 More actions · Answer 3

I don't even know how that "Local System account" looks like.

I guess it's different on each machine.

I tried to work around and granted "Everyone" FULL CONTROL on that network folder but it didn't help.

I did a test on my local SQL 2012 Express. I had the same setting - Local System account.

As soon as I changed it to my Domain account - Backup successfully created a file on network share.

TheMaskedDBA SSCrazy Points: 2787 More actions · Answer 4

I think you only need to change the SQL Agent service account, not the SQL Server service account.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

LocalSystem is local to the machine. You need an account that has rights to get to the network.

You should set a service account that's a domain account, with Everyone permissions and then specific permissions to certain shares for backup.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

If you know any account having enough rights on that drive give it as proxy account on SQL Server properties--> Security

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 7

sqlGDBA (11/30/2012)
I think you only need to change the SQL Agent service account, not the SQL Server service account.

Yes, if you're running all your backups as scheduled jobs, that's true. But if you expect to run ad hoc backup (or restore) commands from SSMS, for example, then I think the SQL Server service also needs access.

John