Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I made a backup maintenance plan in SQL server 2008. When I run the maintenance plan it fails with an error. When I go to the SQL protocol viewer I can look at the log which has been generated. But sometimes the log is shortened in form of unfinished sentences with "..." at the end.

I can see the error message but as mentioned above the error gets shortened in a form that I can't understand the message. Is it somehow possible to bypass this shortening of errors and get the complete error message?

share|improve this question

Yes, you can.

  • Go to the properties of the Job (for that Maintenance Plan)
  • Steps --> Edit
  • Click Advanced
  • Give the path of the outputfile (can be anything) under "Output File"
  • Click Ok to Save the job

From the next run of the job, you will be able to get the complete job log.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.