Results 1 to 4 of 4

Thread: I getting error SQL STATE 42000 error 22029

  1. 02-12-2007, 04:06 PM #1
    indyandumi
    indyandumi is offline Registered User
    Join Date
    Jan 2007
    Posts
    36

    I getting error SQL STATE 42000 error 22029

    Hi guys i used maintanance wizards to schedule, transactional log backups it gave me this error SQLMAINT.EXE Process exit code 1.

    I went to job history and i get this error code SQL STATE 42000 error 22029.

    if any one has hints on how to deal with this i will appreciate
    Reply With Quote Reply With Quote
  2. 02-12-2007, 04:39 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    No other details?

    What is the recovery model for the database? Make sure it is not simple.
    Reply With Quote Reply With Quote
  3. 02-12-2007, 04:56 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check plan's log file for details.
    Reply With Quote Reply With Quote
  4. 02-12-2007, 05:32 PM #4
    indyandumi
    indyandumi is offline Registered User
    Join Date
    Jan 2007
    Posts
    36
    Skhanal , you were right on point my friend, the problem was all the db backups were on simple mode. I chabged it the job run smoothly.

    Thanks man.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules