Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-10-19 : 05:21:09
|
| I have configured a database maintainance plan using enterprise manager,which takes regular backups of the database and the transactionlog files .this plan has created various jobs for performing the maintainance,but the transaction log backup job is failing since the day i started the plan.it says:sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.what can be the possible problem ?please help.thnxs .harshal. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-19 : 10:17:08
|
| 1) How many databases does this maint plan cover ?2) Are they all user databases ?3) What version of SQL (edition and SP)4) What is the recovery model of the databases involved (if SQL2000) or are either selct into/bulk copy or truncate log on checkpoint set on if on SQL7Also check the maintenance plan report for further details. This is usually due to the recovery model of one of the databases in the maint plan being incompatible with transaction log backups. This can be becasue the master database is included (you can take transaction log backups of the master database) or one of the user databases being in simple mode (SQL2000) or having the select into/bulk copy or truncate log on checkpoint set on SQL7HTHJasper Smith |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-10-21 : 05:26:19
|
| this database plan covers all the databases including the system databases.I am using SQL server 2000 and win 2000 Advanced server Operating system.thnxs,harshal. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-21 : 14:29:08
|
| As a first step , separate the plan into 2 plans, one for the system databases and one for the user databases. If all the user databases are in either FULL or BULK LOGGED recovery mode then transaction log backups should work ok, if any are in SIMPLE mode, separate them into another plan. Maintenance plans can have problems figuring out what to do if any of the databases in them can't take a tran log backup due to their recovery mode (although I thought this was fixed - I'll have a look)HTHJasper Smith |
|
|
|
|
|
|
database maintanance plan failure!