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.
· Share on Twitter

Comments

  • 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
    · Share on Twitter
  • DBA007DBA007 Posts: 16
    only one db has this problem on that server
    · Share on Twitter
  • 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
    · Share on Twitter
Sign In or Register to comment.