SQL backup to network drive

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL backup to network drive

SQL backup to network drive

Rate Topic

Display Mode

Topic Options

Author

Message

RVO

Posted Friday, November 30, 2012 10:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 08, 2013 1:32 PM
Points: 33, Visits: 78

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?

Post #1391438

sqlGDBA

Posted Friday, November 30, 2012 10:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:04 PM
Points: 78, Visits: 186

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.

Post #1391453

Perry Whittle

Posted Friday, November 30, 2012 11:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 AM
Points: 5,244, Visits: 11,264

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" Wink

Post #1391467

RVO

Posted Friday, November 30, 2012 12:35 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 08, 2013 1:32 PM
Points: 33, Visits: 78

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.

Post #1391504

sqlGDBA

Posted Friday, November 30, 2012 1:48 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:04 PM
Points: 78, Visits: 186

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

Post #1391546

Steve Jones - SSC Editor

Posted Friday, November 30, 2012 2:09 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:39 AM
Points: 31,529, Visits: 13,866

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1391551

Ratheesh.K.Nair

Posted Monday, December 03, 2012 8:39 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:31 AM
Points: 2,425, Visits: 3,403

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

Post #1391987

John Mitchell-245523

Posted Monday, December 03, 2012 8:44 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 7:03 AM
Points: 4,443, Visits: 7,249

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

Post #1391991

« Prev Topic | Next Topic »

Permissions