Dear Friends,

While I am trying to backup my transaction logs of my databases, running in MS-sql server 2000, I got the following error.

The job failed. The Job was invoked by Schedule 17 (Schedule 1). The last step to run was step 1 (Step 1).

The step 1 says, the following error.
Executed as user: sa. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

while I check my SQl Server logs it says,
Log backed up: Database: model, creation date(time): 2000/08/06(01:40:52), first LSN: 5:278:1, last LSN: 5:282:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:\MS SQL Server_LogFiles\model_tlog_200303041330.TRN'}).

I can see a TRN file created for it.

While configuring this job, i didn't choose the option - 'Verify the integrity of the backup upon completion'.

Can any one advise me why I am getting this error msgs. Is the transaction log backup file created, is a proper backup file or not.

Thanks in advance.