Hey everyone --
I've been having this problem for a couple weeks and was hoping maybe
someone can help out a little bit.
Synopsis:
This SQL agent job contains code to perform a full database backup with
verification and is writing to a local disk array. I typically also use
some code for reporting - declaring variables and inserting them into
a linked server database that I use to monitor all my database backups.
I have tested and used the code repeatedly and am confident it works.
I have ran the code through Query Analyzer and it completes with
success.
I have removed reporting code & used only the backup statement & it
fails.
I have 4 other Agent jobs doing other various tasks that function as
expected.
I have tried deleting & recreating the job & it still fails.
When I enable logging the application log has only one entry for SQL
Agent:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 1/4/2005
Time: 9:36:00 AM
User: N/A
Computer: ComputerName
Description:
SQL Server Scheduled Job 'DBName Full DB Backup'
(0xA4B14FB5A5DE964B8340423E4AC4B67B) - Status: Failed - Invoked on:
2005-01-04 09:36:00 - Message: The job failed. The Job was invoked by
User domain\UserName. The last step to run was step 1 (Step 1).
Any help or ideas would be greatly appreciated. I'm racking my brain
here and for some reason just not able to think of what the problem is.
Chadd
ne******@gmail.com