Re: Various Maintainance Plan Errors

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

1. Is from turning on the setting "Attempt to repair any
minor problems". This will run dbcc checkdb using the
repair_fast option. The repair options require the database
be in single user mode. You don't really want to use the
repair option. If you have an error with a dbcc checkdb, you
don't want things automatically handled as you don't know
the cause of the problem and you would want to be aware of
the issue. If you have an error, you would want to identify
the cause of the problem, look into potential hardware
issues, correct the issues and proceed from there. Sometimes
you may run a repair and sometimes you would restore from
backup - depends on the issue.
To run a repair, you put the database itself in single user
mode using alter database.
2. The database is probably set to simple recovery mode. You
can't backup logs for databases in simple recovery. If that
recovery model is appropriate for the given database, remove
it from the maintenance plan doing transaction log backups.
If it's not the correct recovery model and you need point in
time recoverability, you can change the recovery model to
full.

-Sue

On Mon, 17 Oct 2005 09:07:27 +0100, "Ben"
<Ben@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hi
>
>We have many maintainance plan errors on various databases:
>
>1 - Integrity Checks: Repair statement not processed. Database needs to be
>in single user mode.
> - MSDN:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_
>reslsyserr_2_88u1.asp
> - Does this mean that when I want to run an integrity
>check/repair I need to start in Single User mode as in:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
>_1_start_4nhh.asp
>
>2 - Transaction Log Backup: Backup can not be performed on database
>'db90543'. This sub task is ignored.
>
>Any advice would be much appreciated.
>
>Regards
>B
>
>
>

.

Relevant Pages

  • Re: Various Maintainance Plan Errors
    ... Is from turning on the setting "Attempt to repair any ... The repair options require the database ... > be in single user mode. ... > recovery model is appropriate for the given database, ...
    (microsoft.public.sqlserver.setup)
  • Bizarre data loss running maintenance plan
    ... Apparently the transaction log backups have ... been failing because the database is set to the Simple recovery model. ... I'm losing updates to records that were updated prior to the ...
    (microsoft.public.sqlserver.msde)
  • Re: Truncate SQL server log
    ... You might want to check the recovery model set for your database. ... business does not require transaction log backups for data recovery or other ... effect of data recovery before starting out. ...
    (microsoft.public.sqlserver.programming)
  • Re: cant open shared db
    ... you ned to split your database and get users to run their own ... Select "yes" to repair it. ... local ws, opens the db on the target network share, with the workgroup ... with the repair/compacting process. ...
    (microsoft.public.access.security)
  • What is the best practice to create Maintenance Plans
    ... There is not a definitive answer to the question of which backup is better. ... the database can be recovered to the point ... Full Recovery or Bulk-Logged Recovery model. ... Transaction Log backup for master database is not allowed. ...
    (microsoft.public.sqlserver.security)