event id 208 on sql server 7 HELP

Hi,

For some strange reason all of a sudden, my scheduled jobs are not running. I dont remember changing anything that might cause this but i cant say for sure. The other issue i have is that i cannot backup a database to the default location as shown on the second even below.

Any ideas?

Thanks for your help

Event Type: Warning
Event Source: SQLServerAgent
Event Category: Job Engine
Event ID: 208
Date: 08/09/2006
Time: 12:00:01
User: N/A
Computer: SERVER1
Description:
SQL Server Scheduled Job 'DB Backup Job for 'DBMP-EDB'' (0xC50AD7AF9993294A8134D2F7D10C0ADC) - Status: Failed - Invoked on: 08/09/2006 12:00:00 - Message: The job failed. The Job was invoked by Schedule 23 (Schedule 1). The last step to run was step 1 (Step 1).

Event Type: Error
Event Source: MSSQLServer
Event Category: Kernel
Event ID: 17055
Date: 07/09/2006
Time: 19:30:04
User: NT AUTHORITY\SYSTEM
Computer: SERVER1
Description:
18204 :
BackupDiskFile::CreateMedia: Backup device 'C:\MSSQL7\BACKUP\my_db_200609071930.BAK' failed to create. Operating system error = 5(error not found).
Data:
0000: 1c 47 00 00 10 00 00 00 .G......
0008: 0d 00 00 00 45 00 46 00 ....E.F.
0010: 41 00 43 00 53 00 53 00 A.C.S.S.
0018: 45 00 52 00 56 00 45 00 E.R.V.E.
0020: 52 00 31 00 00 00 00 00 R.1.....
0028: 00 00 ..

Moahmad,

From what I have seen this error comes up when the SQL Server Agent fails to authenticate to the OS or it cannot determine if the owner of the job has access to the OS.

Did this Backup Job work before?

|||

Hi Jeff,

yeah it all worked fine until a couple of weeks ago. The other thing i found is that the "systems managment date manager" service has not started and will not start when i attempt too. Would this have anything to do with it.

thanks for your help

Mo

|||

Here is a copy of the log files:

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SERVER1' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DBMP-EFACS' on Wed Sep 27 12:30:01 2006

Could not create a sub directory for database efacdb. The parent directory will be used instead.[1] Database efacdb: Delete Old Backup Files...
0 file(s) deleted.

Deleting old text reports... 1 file(s) deleted.

End of maintenance plan 'DBMP-EFACS' on Wed Sep 27 12:30:01 2006

SQLMAINT.EXE Process Exit Code: 0 (Success)

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SERVER1' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DBMP-All' on Wed Sep 27 20:00:01 2006

Could not create a sub directory for database model. The parent directory will be used instead.[1] Database model: Transaction Log Backup...
Destination: [C:\MSSQL7\BACKUP\model_tlog_200609272000.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:\MSSQL7\BACKUP\model_tlog_200609272000.TRN'. Device error or device off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
Deleting old text reports... 1 file(s) deleted.

End of maintenance plan 'DBMP-All' on Wed Sep 27 20:00:01 2006

SQLMAINT.EXE Process Exit Code: 1 (Failed)