Re: Optimization Failure in a Maintenance Plan

Tech-Archive recommends: Speed Up your PC by fixing your registry

Sorry, that doesn't ring a bell. I'd re-try it and if it keeps re-occurring, I'd open a case with MS Support (assuming you've Googled it already, of course).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Fogster" <colinehill@xxxxxxxxxxx> wrote in message news:228e55b6-0a3b-4dbd-9851-f3887c3cd44e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Information_Schema disappears?
    ... this sounds like an MS Support case to me... ... Tibor Karaszi, SQL Server MVP ... > It is truly vexing, and we'd appreciate some input here!! ...
    (microsoft.public.sqlserver.server)
  • Re: Optimization Failure in a Maintenance Plan
    ... Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi ... 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)