IBM Support

MSSQL scheduled backups report return code 1904

Troubleshooting


Problem

Tivoli Data Protection for MS SQL reports return code 1904 for scheduled backups

Symptom

In an environment where the Tivoli Data Protection for MS SQL has been setup for executing scheduled backups via Tivoli Storage Manager scheduler service, the following error may be seen in the Tivoli Storage Manager scheduler and error log:
------------------------------------------------------------
06/05/2014 13:52:11 Schedule Name: SQL_TDP_TEST
06/05/2014 13:52:11 Action: Command
06/05/2014 13:52:11 Objects:
c:\scripts\sqlfull.cmd
06/05/2014 13:52:11 Options:
06/05/2014 13:52:11 Server Window Start: 13:37:51 on 06/05/2014
06/05/2014 13:52:11
------------------------------------------------------------
06/05/2014 13:52:11
Executing scheduled command now.
06/05/2014 13:52:11
Executing Operating System command or script:
c:\scripts\sqlfull.cmd
06/05/2014 13:52:25 Finished command. Return code is: 1904
06/05/2014 13:52:25 ANS1909E The scheduled command failed.
06/05/2014 13:52:25 ANS1512E Scheduled event 'SQL_TDP_TEST'
failed. Return code = 1904.

Cause

The error code 1904 indicates a permissions issue with the userID that starts the
scheduler service. The userID setup to start the scheduler service at Windows startup has not all the required permissions and roles to manage the backup operation in the MS SQL Database. Usually this error occurs if the scheduler service has been setup to start with the Local System account.

Resolving The Problem

Verify that the Tivoli Storage Manager Scheduler service is set up to be started with a userID that belongs to the SQL sysadmin group/role. Contact the DB Administrator for obtaining the correct information about the userID.

[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for MS SQL","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21678144