Re: Single user mode after maint plan

From: John (jsparrowNOSPAM_at_ecclesdeletethiscollege.ac.uk)
Date: 09/05/04 

Date: Sun, 5 Sep 2004 15:58:59 +0100

Thanks Nigel.

It would be cool if the 'Maintainance Plan' wizard created a script that
could then be edited... anything like that planned for SQL 2005?

John

"Nigel Rivett" <sqlnr@hotmail.com> wrote in message
news:F0428A66-2AE1-45B9-A1B7-94593BE967CB@microsoft.com...
>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: Single user mode after maint plan
    ... Wayne Snyder, MCDBA, SQL Server MVP ... "John" wrote in message ... > It would be cool if the 'Maintainance Plan' wizard created a script that ... >>> the maintainance plan. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 - Backup Maintainance Plan Failed
    ... The SQL Runs perfectly if I run it in Query Manager, ... We have a new instance of SQL Server 2005 and have created a backup ... maintainance plan which is failing with these errors. ... Operator Net sent ...
    (microsoft.public.sqlserver.setup)
Loading