April 15, 2008 at 9:04 am
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.
April 15, 2008 at 2:53 pm
I think you are using different user for both jobs. Please verify whether user used in failed job has proper access.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 16, 2008 at 6:13 am
You are backing up to a network share. Does the SQL Server Agent service startup user have rights to write to that network share?
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
April 16, 2008 at 10:08 pm
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.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
April 18, 2008 at 4:28 am
Operating system error 53 means 'the network path was not found' so looks like your path specified to backup device is wrong.
---------------------------------------------------------------------
April 18, 2008 at 7:49 am
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
September 5, 2013 at 8:27 am
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply