Monday, March 12, 2012

error when backup transaction log

hi guys,


I'm using sql 2000 and I got this error when I run backup transaction log in maintenence plan.
"The job failed. The Job was invoked by Schedule 38 (Schedule 1). The last step to run was step 1 (Step 1)."

but even it return an error the backup file is created.

please advice.

thanks

There has to be a more detailed error, if you did not choose to log the job execution, try to do this, as this. Otherwiese you will only get this common exception which does not really help very much.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

hi jens,

after I try to backup just 1 database. it went ok.

maybe it because I backup master and msdb also. but I wonder why is my transaction log file is keep on growing ?

should it get truncated everytime the backup is successfull ? either full backup or transaction log backup right

regards,

-dedys

No comments:

Post a Comment