Running a sql server 2008 job to back up to network folder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Running a sql server 2008 job to back up to...

28 posts, Page 1 of 3

1 2 3 »»»

Running a sql server 2008 job to back up to network folder

Rate Topic

Display Mode

Topic Options

Author

Message

mashikoo

Posted Thursday, December 30, 2010 12:40 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, August 28, 2012 6:43 AM
Points: 70, Visits: 145

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

PaulB-TheOneAndOnly

Posted Thursday, December 30, 2010 12:57 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 2,988, Visits: 4,410

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

Elliott Whitlow

Posted Thursday, December 30, 2010 1:17 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

mashikoo

Posted Thursday, December 30, 2010 1:20 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, August 28, 2012 6:43 AM
Points: 70, Visits: 145

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

mashikoo

Posted Thursday, December 30, 2010 1:54 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, August 28, 2012 6:43 AM
Points: 70, Visits: 145

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

Jo Pattyn

Posted Thursday, December 30, 2010 3:19 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:09 AM
Points: 1,332, Visits: 4,313

The sqlagent (user) has access to the share?

Post #1041233

Adiga

Posted Friday, December 31, 2010 12:24 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:23 PM
Points: 1,618, Visits: 20,901

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

Nishtha-486860

Posted Monday, April 04, 2011 12:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 20, 2011 1:54 PM
Points: 5, Visits: 42

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

Jo Pattyn

Posted Monday, April 04, 2011 2:42 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:09 AM
Points: 1,332, Visits: 4,313

apart from the share permissions, does the agent also has the necessary NTFS-permissions (if underlying filesystem is ntfs)?

Post #1088289

Nishtha-486860

Posted Monday, April 04, 2011 2:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 20, 2011 1:54 PM
Points: 5, Visits: 42

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 »

28 posts, Page 1 of 3

1 2 3 »»»

Permissions