Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scheduled backup job sometimes does not run

Status
Not open for further replies.

StevenK

Programmer
Jan 5, 2001
1,294
GB
We have seen an odd situation with one of the client sites which we support.
I have set up a DTS package that backs up their 2 main SQL Server databases - i.e. DATABASE1 and DATABASE2.
This has then been scheduled to run each week day (Monday - Friday) at 08.00, 11.00 and 14.00 (8am, 11am and 2pm).
This runs via the SQL Server Agent (which is set to start at start of O/S in case the server needs to be rebooted, etc.)
This job backs up the 2 databases to an external hard drive - including a datetime stamp to indicate when it was run - i.e. DATABASE1_BU_200711011000.Bak (for 01/11/2007 10.00am).

I tend to connect to their server every now and again for different support jobs - and review the state of play with this backup.
Sometimes I'm finding that this job is not / has not been running.
When I review the Jobs via SQL Server Enterprise Manager I see that this job has a Status of 'Executing Job Step 1 (Backup Databases)' (which started yesterday at 14.00 say).

It's as if the job starts, and simply does not run.
I then delete the scheduled job, and re-schedule it from the saved DTS package.

Is anyone aware of any issues that we should need to know for running a job like this onto an external hard drive device?

Any help would be appreciated.
Thanks in advance,
Steve
 
If the job has a status of running and is hung, that means that the package attempted to start via the dtsrun command and it hung for some reason.

What happens if you simply stop the job and restart it?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top