How can we help you today? How can we help you today?

sqlbackup failed

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.
DBA007
0

Comments

3 comments

Sort by
  • petey
    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?
    petey
    0
  • DBA007
    only one db has this problem on that server
    DBA007
    0
  • petey
    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 = [...]"'
    petey
    0

Add comment

Please sign in to leave a comment.