Re: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 05/11/04
- Next message: Tibor Karaszi: "Re: Resizing an existing DB"
- Previous message: Julie: "Resizing an existing DB"
- In reply to: jjlm: "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 09:58:11 +0100
Master, msdb, Northwind and pubs are set to Simple recovery. That means that
the transaction log can not be backed up, which causwes the error you see.
There is hardly any need to back up Northwind and pubs (you can rebuild them
from a script that comes with the isntallation anyway) and you can create a
separate maintenance plan for the system database, that doesn't do a
transaction log backup.
-- Jacco Schalkwijk SQL Server MVP "jjlm" <jlanteri@citco.com> wrote in message news:D1F6CEDB-95A0-497F-A5E2-63A47056ECC4@microsoft.com... > Hi, looking in database maintenance plans history (thanks for the way) i found those message: > Backup can not be performed on this database. This sub task is ignored > For Master,Pubs,NorthWind and Pubs... > My maintenance plan is > Backup all databases and Transaction log for all databases every day at 8:00 PM with a report ... > Is there something i missed? > Thanks for you help
- Next message: Tibor Karaszi: "Re: Resizing an existing DB"
- Previous message: Julie: "Resizing an existing DB"
- In reply to: jjlm: "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
