What are the challenges you face when working across database platforms? Take the survey
Options

sqlbackup failed

DBA007DBA007 Posts: 16
edited October 19, 2010 8:53PM in SQL Backup Previous Versions
my backup job was failing with below error
SQL Backup failed with exit code: 880 SQL error code: 942 [SQLSTATE 42000] (Error 50000). The step failed.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Error code 880 indicates that the user does not have rights to back up the database. Does the owner of the job have the necessary rights?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    only one db has this problem on that server
  • Options
    peteypetey Posts: 2,358 New member
    Try backing up that database using SQL Backup:

    - start SQL Server Management Studio
    - log on to SQL Server using the same user account as the owner of the backup job that failed
    - back up that database using SQL Backup e.g.
    EXEC master..sqlbackup '-sql "BACKUP DATABASE [...] TO DISK = [...]"'
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.