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, December 30, 2010 12:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 12:21 PM
Points: 72, Visits: 159
I'm trying to schedule a back up database task to backup some specific databases to a network folder but kept getting this error message-

" Executing the query "BACKUP DATABASE [XDevSL7Utilities] TO DISK = N'\\..." failed with the following error: "Cannot open backup device '\\fscorp\DynDB-Backup\Backup-vDB2001\Database_backup_2010_12_30_134701_5618693.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:47:00 PM Finished: 1:47:01 PM Elapsed: 1.031 seconds. The package execution failed. The step failed"


Any help or guidance will be greatly appreciated.
Post #1041144
Posted Thursday, December 30, 2010 12:57 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
mashikoo (12/30/2010)
I'm trying to schedule a back up database task to backup some specific databases to a network folder...


1- Share a folder located on target remote drive
2- Map remote share in local server
3- Point backup to mapped drive

Problem is that backup speed will be limited by network speed - pretty poor performance.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1041152
Posted Thursday, December 30, 2010 1:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
I have had no end to trouble with mapped drives when not connected as an interactive user. I strongly suggest using a UNC path instead of a mapped drive.

CEWII
Post #1041173
Posted Thursday, December 30, 2010 1:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 12:21 PM
Points: 72, Visits: 159
Thanks, but I'm not trying to backup to a mapped drive but to a network share. Does the steps you metioned earlier apply?

Appreciate!
Post #1041174
Posted Thursday, December 30, 2010 1:54 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 12:21 PM
Points: 72, Visits: 159
Thanks Elliot,

Currently i'm able to backup my sqlserver 2005 databases to a shared folder without any glitch. I'm only having trouble doing the same to my sql server 2008 databases hence the error I stated earlier.
Post #1041197
Posted Thursday, December 30, 2010 3:19 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:50 AM
Points: 1,394, Visits: 6,590
The sqlagent (user) has access to the share?
Post #1041233
Posted Friday, December 31, 2010 12:24 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
As Jo suggested, check if the SQL Server Agent service account has FULL permissions on the network share.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1041292
Posted Monday, April 4, 2011 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 8:37 AM
Points: 5, Visits: 44
I have the similar problem. and the SQL agent has read, write and modify access to the shared folder BUT FULL Control.

Please help!!!
Post #1088245
Posted Monday, April 4, 2011 2:42 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:50 AM
Points: 1,394, Visits: 6,590
apart from the share permissions, does the agent also has the necessary NTFS-permissions (if underlying filesystem is ntfs)?
Post #1088289
Posted Monday, April 4, 2011 2:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 8:37 AM
Points: 5, Visits: 44
Yes Im logged into the server as the agent domain account and I can manually create, delete txt files on the shared folder. But when I try to backup the database on the shared folder it fails with access denied error.
Post #1088299
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse