Unknown Error Code

• David.Poole

  SSC Guru

  Points: 76034

  More actions

  May 6, 2003 at 4:00 am

  #105653

  I have maintenance plans set up for all my user databases however the backup transaction log backup part of the maintenance plan fails generating the error below.

  quote:

  ---

  Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

  ---

  Does anyone know what Error 22029 is?

  I've looked in sysmessages and BOL but cannot find this entry.

  Thanks

  LinkedIn Profile

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 6, 2003 at 4:18 am

  #456263

  Take a look here for additional help. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q288577

• Robert Lu

  SSCrazy

  Points: 2488

  More actions

  May 6, 2003 at 3:44 pm

  #456342

  check out the database option recovery model

  is full instead of simple.

  Robert