Backup Job is failing - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Backup Job is failing

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-12-24 : 23:09:50

Backup job for User databases is failing.
I found below errors
View job history

Step 0:
The job failed. The job was invoked by schedule 4(DBMP_User). The last step to run was step 1(subplan)
Step 1:

Message: Executed as user Servername\System. The package execution failed. The step failed

Appln-event log:

SQL server scheduled job DBMP_User failed. Invoked on 2007-12-24 , the job was failed.

Sql server error log

Database backed up. DBname creation,date()time……paged dumped 8434659,first LSN: 21126:101410:48,last LSN :21128:933:1, number of dump devices:1, device information: file=1,type=disk (E:\MSSQL\BACKUP\ )
This is an informational message only. No user action is required

Error log:

Date:
Log: SQL Agent (current …)
Message:
(396) An idle CPU condition has not been defined-OnIdle job schedules will have no effect.

Please advice how to proceed?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-24 : 23:38:19

What's job schedule? Can you run the job manually? Any backup failure message in sql server log?

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-12-24 : 23:46:10

every day 8 pm, scheduled job failed and also run maually it is also failed. no backup failure message in sql log

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-24 : 23:59:09

What's sql version? Do you run db backup in dts(ssis) package?

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-12-25 : 00:01:53

SQL Server 2005, Job was scheduled in DataBase Maintenance Plan.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-25 : 00:04:15

What does plan log file say then?

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-12-25 : 00:13:43

There is no task in maint plan log file summery

Maintenance plan for User db's contains

Reorganize index
Full backup
Maintenance cleanup task for backup files older than 3 days
History cleanup task

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-25 : 00:15:15

Should double check your maintenance plan.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-25 : 00:34:31

So first step is reorganize index? Checked job history step details?

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-12-25 : 01:45:47

I have checked, One user database size is 105 GB, I have deleted old backup files and started job manually...let's see

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-12-25 : 16:54:26

Hi Rmiao,

It is due to space issue, I did't selected checkbox in maintenance cleanup history-deltete from subfolders to delete old backup files,so it is looking for .bkp files in backup folder rather than backup\user and did't not find, hence job is failing due to space problem, It is a SQL Server 2005 server, Now job is succeded.

One question:

How to recycle sql error logs, because 29503451 records are there???

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-25 : 17:00:44

sp_cycle_errorlog

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources