RE: Single user mode after maint plan

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

From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 09/05/04 

Date: Sun, 5 Sep 2004 04:29:04 -0700

I would advise to not use maint plans - code it yourself so you are in
control of what it does and you won't have these problems and gain a lot more
knowledge..

"John" wrote:

> Sometimes, my database(s) remain in single user mode following execution of
> the maintainance plan.
>
> I've seen the messages relating to SQL Server 7 and 'Fix minor db problems'
> in the plan. Does this bug also apply to SQL Server 2000 sp 3??
>
> Is there any other workaround except to turn off 'Fix minor problems' in the
> plan?
>
> Thanks,
>
> John
>
>
>

Relevant Pages

  • Re: Slow Start-up (I know this question has been asked before)
    ... And you John ... Enquire, plan and execute ... check the boxes before Peak Memory Usage and Virtual Memory ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: reports
    ... "John" wrote: ... down the essence of a plan into a single metric - it can be so ... or some similar classical schedule analysis approach. ... In the Filter Definition window, ...
    (microsoft.public.project)
  • Re: Simple Timesheet
    ... Thanks again John, I wrote a huge post this morning but deleted rather than ... > has) set up Project as a shop floor schedule app. ... > My experience says that too detailed a plan (i.e. hour to hour or day to ...
    (microsoft.public.project)
  • Re: Default Tasks Constraint
    ... > constraint, the start date is set as ... Am I nuts or what? ... John ... >> What's wrong is your method of creating the plan. ...
    (microsoft.public.project)
  • Re: Wreckfest 2007
    ... then moved to the ball on the pilot house where we all ... attention to what the plan is during the pre-dive briefing. ... trained GUE divers as well as John and I, would you expect any less than ... John and I watched Slate unhook and Capt Bob hook while on the line. ...
    (rec.scuba)