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

Backup Job gives Error Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2008 9:04 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 121, Visits: 231
HI Guys.
i cannt' understand what's going on the server.. actually i have created a two jobs for full backup for my databases.. One is running perfect but one is giving me following error.

Can any one tells me where i m doing mistake.

Message
Executed as user: Domain\user. Cannot open backup device 'Database_Full(\\192.0.0.1\Backups\FULL_Backups\database_Full.BAK)'. Operating system error 53(error not found). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Post #485089
Posted Tuesday, April 15, 2008 2:53 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:36 PM
Points: 1,339, Visits: 596
I think you are using different user for both jobs. Please verify whether user used in failed job has proper access.

--www.sqlvillage.com
Post #485307
Posted Wednesday, April 16, 2008 6:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 26, 2014 12:57 AM
Points: 343, Visits: 1,520
You are backing up to a network share. Does the SQL Server Agent service startup user have rights to write to that network share?

Ray Mond
Yohz Software
Providing SQL Server database tools for 9 years and counting.
http://www.yohz.com
Post #485585
Posted Wednesday, April 16, 2008 10:08 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, October 26, 2014 12:47 PM
Points: 2,665, Visits: 831
Also make sure the folder structure exists - backup will not create any folder structure you specify in the backup command, it has to exist first.




Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Post #486088
Posted Friday, April 18, 2008 4:28 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:44 PM
Points: 5,881, Visits: 13,016
Operating system error 53 means 'the network path was not found' so looks like your path specified to backup device is wrong.

---------------------------------------------------------------------

Post #487038
Posted Friday, April 18, 2008 7:49 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 7, 2009 7:46 AM
Points: 126, Visits: 176
When you backup to a network share make sure you use a full UNC path to the target.
For example \\MyServerName\MyFolder\MySubFolder\MyBackupFile.BAK
Post #487199
Posted Thursday, September 5, 2013 8:27 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 8:57 PM
Points: 139, Visits: 404
it is is same system daily it is working fine today only it is not working.

we have 2 steps in job one is working fine and this one is not working.
Post #1491817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse