Scheduled backup does not start

carmelcw · April 27, 2006 10:01PM

Hi,

I have used the wizard to create the Schedule backup, which backup all user database in every Mon-Fri at 12:00am.

But when I come back in the morning, the job doesn't seen to be run and there is no log indicate the job fail.

Do I have missed something?

Thanks for everyone in advance.
Carmel Lee

petey · April 28, 2006 3:38AM

The backup task is created as a SQL Server Agent job. Is the SQL Server Agent service started?

carmelcw · April 29, 2006 1:47AM

Hi Peter,

I have checked the SQL Server Agent which is started. But It still not running at the scheduled time.

I have tried to force the job to run and It can run success.

Do you know what will occur that not run in the scheduled time?

Many thanks,
Carmel Lee

petey · April 30, 2006 3:19PM

What do you see in the job history for that job? If it started, there should be some bit of history information there.

If it didn't even start, I would check if there is a schedule set up for that job, that the schedule is enabled and also that the job itself is enabled.

afrush · May 4, 2006 1:32PM

I created a scheduled backup to backup 15 databases and the job never starts. Everything is enabled and when I check the history there is no history for the job. When I manually try and start it it does not run. When copy the script and run it in SQL Analyzer it runs.

petey · May 4, 2006 2:29PM

Could you pls try creating a similar job manually, with the same script, and try running it? This usually reveals subtle differences in the setup. If the manually created job runs, let us know the missing settings in the SQB Backup created job. Thanks.

Scheduled backup does not start

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk