You might use something like that (part of my logshipping-procedures):

/* ---------------------------------------------------------------------------*/

-- Vollbackup.sql

-- T-SQL-Script zum Erstellen eines Vollbackups aller Datenbanken eines

-- beliebigen Microsoft-SQL-Servers (2000)

-- Erstellt am: 3.11.2003

-- Author:Karl Klingler, karl.klingler@dr-stahl.de...

explorer - right mouseclick on the DefDir- properties - security

Is SYSTEM visible?

has SYSTEM the write-permission?

(by the way, what is UseDefDir? Default Directory?

obviously the job can only succeed if is's account hat write permissions for the directory where the backupfiles will reside. You should verify this!

Karl

Hi,

you might do a "backup log with truncate", then a "backup database",

and until the next DB-Backup do a "backup log with no_truncate" every 15 minutes or so.

Are the Jobs really ended, or are they running still?

Try stopping and restarting the SQLServerAgent...

Don't forget that the use-statement is only valid during the execution of the exec-command.

-> Add anything you want to be done to the string @MySQL