Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql2020
Yak Posting Veteran
54 Posts |
 Posted - 2011-09-03 : 08:51:15
|
| We are running backup job through sql agent... some time we are facing backups was failed but in sqlagent history it showing as success... if i saw in logs backup failed msg was there.... and last step was successfull msg also there... i am not able to find what is the exact issue... if any guy facing same type of issue please let me know what is the exact issue....in that backup drive we taking tlog backup also taking we shedule every day 1 full backup... and every 15 mins tlog backup...please help me on this.sql2020 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-06 : 09:42:31
|
| What does the windows application log show? |
 |
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2011-09-07 : 15:25:45
|
| Are you running those backups from scripts? Can you post the scripts you are using? It sounds like the script might be logging failures but the steps are still completing...is that correct?Steve |
|
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2011-09-09 : 02:22:41
|
| this is the log.... backup was failure but in history its showing success.. pls help me to troubleshootessageExecuted as user: xyz. *********************************************************************************** [SQLSTATE 01000] (Message 0) backup started Sep 1 2011 9:31PM [SQLSTATE 01000] (Message 0) *********************************************************************************** [SQLSTATE 01000] (Message 0) exec master..xp_cmdshell " md g:\mssql\backup\abcd\" [SQLSTATE 01000] (Message 0) waitfor delay '00:00:19' [SQLSTATE 01000] (Message 0) sp_addumpdevice 'disk' , 'dvc_abcd_g1_yr2011mo9da8hr21mi31' , 'g:\mssql\backup\abcd\abcd_g1_yr2011mo9da1hr21mi31.bak' [SQLSTATE 01000] (Message 0) backup database abcd to dvc_abcd_g1_yr2011mo9da1hr21mi31 [SQLSTATE 01000] (Message 0) !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! [SQLSTATE 01000] (Message 0) backup failed [SQLSTATE 01000] (Message 0) error number - 3013 [SQLSTATE 01000] (Message 0) BACKUP DATABASE is terminating abnormally. [SQLSTATE 01000] (Message 0) !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! [SQLSTATE 01000] (Message 0). The step succeeded.sql2020 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-09 : 02:31:40
|
| Is 'g:\mssql\backup\abcd\abcd_g1_yr2011mo9da1hr21mi31.bak' a network location, or local to the server?Is it a compressed folder?Any chance the G: drive was full, at the time? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-09-09 : 08:07:24
|
| Doy ou want to troubleshoot why the backup failed or why the log says success when it failed? If it's the second than look at the advance properties of your job step; does it say "On failure action: quit the job reporting failure"?- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2011-09-10 : 07:56:26
|
| Backup failed because of space issue only... my question is why its shown as success in job history if backup fails ... i set if failure report as "On failure action: quit the job reporting failure" onlybut its showing success..sql2020 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-10 : 14:05:29
|
| Is the backup generated by a stored procedure that you have written?Maybe your Sproc is returning 0 even if the error occurs? |
|
|
|
|
|
|
Backup failed