Re: Optimization Failure in a Maintenance Plan

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mar 10, 8:30 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@xxxxxxxxxxxxxxxxxx> wrote:
Specify for the plan to create a report file and check that file for error messages. "Failed"
doesn't give us much to go on. :-)

--
Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

"Fogster" <colineh...@xxxxxxxxxxx> wrote in message

news:9d86c84d-1c30-4554-9777-38b3c213184c@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi,

We are getting a failure on a Optimization Job for a DB Maintenance
Plan.
The event log states a 208 error with the Job Engine.

The Job History is:
The job failed.  The Job was invoked by Schedule 88 (Schedule 1).  The
last step to run was step 1 (Step 1).

Any ideas or pointers?

thanks in advance- Hide quoted text -

- Show quoted text -

Hi,

Finally got to look at the server again and the error in the log
is......

[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has
been disconnected. You must reconnect to perform this operation.
.

Relevant Pages

  • Re: Optimization Failure in a Maintenance Plan
    ... I'd re-try it and if it keeps re-occurring, I'd open a case with MS Support. ... Tibor Karaszi, SQL Server MVP ... > The event log states a 208 error with the Job Engine. ...
    (microsoft.public.sqlserver.tools)
  • Re: What should be my reply?
    ... Tibor Karaszi, SQL Server MVP ... "Chip" wrote in message ... >>find the recommendations to delete the tlog file. ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: When an update occurs, what happens to the indexes
    ... Microsoft SQL Server Storage Engine ... UPDATE which in SET changes 5 ... place in the index tree. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Indexes
    ... because we have a clustered index but I was expecting ... Only one row fit per page, so SQL Server ... You have 100000 rows in the table and 1000 rows fit per index page. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Auto Exiting Store Procedures
    ... "Peter" wrote in message ... SQL Server will terminate the batch. ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)