Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Running a sql server 2008 job to back up to network folder Expand / Collapse
Author
Message
Posted Thursday, November 3, 2011 11:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 24, 2011 1:44 AM
Points: 13, Visits: 33
Free download EaseUS Todo Backup Advanced Server to backup your database (2000 2005 2008) with backup schedule (daily weekly monthly) to automatic backup SQL Server.
Post #1200383
Posted Wednesday, January 11, 2012 3:10 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 101, Visits: 276

We're running into the same user. I made sure the following:
- running SQL 2008 SQL Agent as a Windows admin account called "SqlService"
- ensured that that account has full access to the UNC directory
- I can create a backup file to a local folder through the job
- it warns me on the manual backup file that it can't verify the UNC location
- I tried mapping the UNC to a drive letter without success (cannot find the path specified)
- I tried logging in as myself (a windows admin, sql server sysadmin) to backup to any network drive (cannot find the path specified)

Just don't know how to proceed from here. I can't get a directory in the job, as asked by Steve Jones.


Post #1234417
Posted Thursday, January 12, 2012 5:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 1,381, Visits: 6,461
Have a look at the recent article regarding sql server jobs
Post #1234668
Posted Friday, October 5, 2012 2:37 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 10, 2014 4:15 AM
Points: 293, Visits: 816
I'm having the same issue. My sqlservice and agent accounts have full access to the cifs. I can manually browse and create/delete folders while logged on as those accounts.

My backup maintenance plan is run by a SQL Server login, but does not complete a backup to the cifs. Fails with access denied.
Post #1369309
Posted Thursday, November 1, 2012 2:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 7:41 PM
Points: 1, Visits: 21
Check that there is no space on the end of the database name
Post #1380033
Posted Thursday, November 1, 2012 3:32 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 10, 2014 4:15 AM
Points: 293, Visits: 816
Bouncing the box worked for me. I believe it had something to do with SPN registration.
Post #1380066
Posted Thursday, January 3, 2013 8:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 2:30 PM
Points: 4, Visits: 76
Did you get solution to this? I have same issue? Agent service account has full access on shared folder. Manually I can create files inside the folder but SQL job fails. I tried using \\Server\folder , \\server\Z$\folder and as mapped network drive but nothing works.
Post #1402412
Posted Tuesday, May 7, 2013 7:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
for your acount no permission to write the data on the network folder
possible soluation : give permissions on network folder for your acount
Post #1450117
Posted Monday, June 23, 2014 11:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 25, 2014 1:23 AM
Points: 24, Visits: 64
Your SQL Server account has to have the access to the shred drive. It means the account that your SQL Server service runs on has to have read/write/delete permissions on the network share. If the SQL Server Service account runs under the Network Service then you would have to add the computer account rights to the shared folder.
Regards,
N.
Post #1585206
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse