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 03, 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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 3:12 PM
Points: 92, Visits: 233

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: Today @ 7:07 PM
Points: 1,356, Visits: 5,696
Have a look at the recent article regarding sql server jobs
Post #1234668
Posted Friday, October 05, 2012 2:37 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 280, Visits: 763
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 01, 2012 2:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:57 PM
Points: 1, Visits: 14
Check that there is no space on the end of the database name
Post #1380033
Posted Thursday, November 01, 2012 3:32 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 280, Visits: 763
Bouncing the box worked for me. I believe it had something to do with SPN registration.
Post #1380066
Posted Thursday, January 03, 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 07, 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
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse