Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Question Unanswered: Pending Backup - Sqlstate=58005

    Hi all!!!

    I was trying to make a backup and i do not know what i did wrong, because everytime i try to connect to the database, this message appears:

    SQL1116N A connection to or activation of database "TEST" cannot be made
    because of BACKUP PENDING. SQLSTATE=57019

    How can I delete that pending process?? Or how can I launch the backup?
    Every time i try to make the backup this message appears:
    SQL0902C A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed. SQLSTATE=58005

    Heeeeeelp!!!!!!!!!1

    Thank you very much!

  2. #2
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    78

    Re: Pending Backup - Sqlstate=58005

    Hey Garcia,

    on the error SQL1116N there´s this user response:
    "User Response: Back up the database by calling the BACKUP
    routine or, if roll-recovery is not required, set the log retain
    and user exit database configuration parameters off."

    If you can´t backup the database, try changing the roll-recovery off on the database parameter and see if the database is still in backup pending. If yes, with those parameter off, try backing up the database once again.

    HTH
    Fernando

    Originally posted by rgarcia
    Hi all!!!

    I was trying to make a backup and i do not know what i did wrong, because everytime i try to connect to the database, this message appears:

    SQL1116N A connection to or activation of database "TEST" cannot be made
    because of BACKUP PENDING. SQLSTATE=57019

    How can I delete that pending process?? Or how can I launch the backup?
    Every time i try to make the backup this message appears:
    SQL0902C A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed. SQLSTATE=58005

    Heeeeeelp!!!!!!!!!1

    Thank you very much!

  3. #3
    Join Date
    Jan 2003
    Posts
    21

    Re: Pending Backup - Sqlstate=58005

    Thank you Fernando!!!!
    Cheers


    Originally posted by F.OHANA
    Hey Garcia,

    on the error SQL1116N there´s this user response:
    "User Response: Back up the database by calling the BACKUP
    routine or, if roll-recovery is not required, set the log retain
    and user exit database configuration parameters off."

    If you can´t backup the database, try changing the roll-recovery off on the database parameter and see if the database is still in backup pending. If yes, with those parameter off, try backing up the database once again.

    HTH
    Fernando

Posting Permissions

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