June 22, 2012 at 9:26 am
Am getting the following error when I add a new database into the database maintenance plan and run it:
Executing the query "BACKUP DATABASE [Tax ] TO DISK = N'E:\\MSSQL..." failed with the following error: "Cannot open backup device 'E:\\MSSQL\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Backup\\Tax \\Tax _backup_2012_06_22_110243_9439919.bak'. Operating system error 3(The system cannot find the path specified.).
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.
Please help me fix this
June 22, 2012 at 10:21 am
The error indicates that the folder you are attempting to write the backup to does not exist. Confirm that you can access the full path yourself.
June 22, 2012 at 10:31 am
And note that there's a space in the folder name because the database has a trailing space in its name
Backup\\Tax \\
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2012 at 5:52 pm
Hi,
This happens when there is a permission issue with the ID which you are running the job or there is a Drive corruption where the backups are executing
Srikanth Reddy Kundur
June 23, 2012 at 5:38 am
ksrikanth77 (6/22/2012)
This happens when there is a permission issue with the ID which you are running the job or there is a Drive corruption where the backups are executing
It's not a permissions issue, that would be operating system error 5 (Access denied). The reason is very clear in the error message
Operating system error 3(The system cannot find the path specified.).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2012 at 6:41 am
Hi,
Executing the query "BACKUP LOG [WSS_Content_AutoZ] TO DISK = N'\\\\data1\\SQL Server Backups\\HAWDB1_Backups\\WSS_Content_AutoZ\\WSS_Content_AutoZ_backup_201206201130.trn' WITH NOFORMAT, NOINIT, NAME = N'WSS_Content_AutoZ_backup_20120620113002', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot open backup device '\\\\Osidata1\\SQL Server Backups\\HAWDB1_Backups\\WSS_Content_AutoZ\\WSS_Content_AutoZ_backup_201206201130.trn'. Operating system error 53(The network path was not found.).
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
See the above message which we are receiveing from almost 4 months from now, the message says Network path was not found, however the real problem is not the network path sometimes this job fails with this message but if we see the actual backup it will be availble in the backup path. This issue was there in a backup network server with 2003 OS. Later we found that there is a disk corruption which we changed and also the OS to 2008 which got resolved. The DMP sometimes gives you a wrong message on the status of the activity which it performed. Not sure whether this is a bug in DMP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply