Log file backup failure for two jobs

Question

Log file backup failure for two jobs

kaplan71

Hall of Fame

Points: 3634
More actions
January 31, 2019 at 2:26 pm

#370389

Hello --
Two backup jobs for the log files on our server started failing this afternoon. I have been going over the log files, and I have not been able to determine what is the root cause.
The error log for the first job is the following:
Date        1/31/2019 4:11:41 PM
Log        Job History (DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH CURRENT - LOG)
Step ID        1
Server        MGHRORAYSQL\RAYCLINICAL
Job Name        DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH CURRENT - LOG
Step Name        DatabaseBackup - USER_DATABASES - LOG
Duration        00:00:04
Sql Severity    0
Sql Message ID    0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted    0
Message
Executed as user: NT Service\SQLAgent$RAYCLINICAL. ...rsion: 11.0.7001.0 Edition: Standard Edition (64-bit) Platform: Windows Procedure: [master].[dbo].[DatabaseBackup] Parameters: @databases = 'RayStationClinicDB_503_MGH_Q4_2018, RayStationClinicDB_503_MGH_Scripting_Tegile, RayStationMachineDB_503_MGH_Q1_2018, RayStationPatientDB_503_MGH_scripting, RayStationPatientDB_503_MGH_Q1_2019', @Directory = 'H:\RAYSTATION_BACKUPS', @BackupType = 'LOG', @verify = 'Y', @CleanupTime = 48, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @FileName = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${AvailabilityGroupName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @FileExtensionFull = NULL, @FileExtensionDiff = NULL, @FileExtensionLog = NULL, @Init = 'N', @DatabaseOrder = NULL, @Da... Version: 2018-07-16 18:32:21 Source: https://ola.hallengren.com Msg 50000, Level 16, State 1, Server MGHRORAYSQL\RAYCLINICAL, Procedure DatabaseBackup, Line 1402 The following databases in the @databases parameter do not exist: [RayStationPatientDB_503_MGH_scripting]. Date and time: 2019-01-31 16:11:41 Database: [RayStationClinicDB_503_MGH_Q4_2018] Status: ONLINE Standby: No Updateability: READ_WRITE User access: MULTI_USER Is accessible: Yes Recovery model: FULL Encrypted: No Differential base LSN: 615000000214000037 Last log backup LSN: 615000000253900001 Date and time: 2019-01-31 16:11:41 Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'H:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q4_2018\LOG' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:11:41 Date and time: 2019-01-31 16:11:41 Command: BACKUP LOG [RayStationClinicDB_503_MGH_Q4_2018] TO DISK = N'H:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q4_2018\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_MGH_Q4_2018_LOG_20190131_161141.trn' WITH CHECKSUM, NO_COMPRESSION Processed 1 pages for database 'RayStationClinicDB_503_MGH_Q4_2018', file 'RayStationClinicDB_25189_log' on file 1. BACKUP LOG successfully processed 1 pages in 0.004 seconds (0.366 MB/sec). Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:11:41 Date and time: 2019-01-31 16:11:41 Command: RESTORE VERIFYONLY FROM DISK = N'H:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q4_2018\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_MGH... Process Exit Code 1. The step failed.
The error log for the second job is shown below:
Date        1/31/2019 4:00:00 PM
Log        Job History (DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH PREVIOUS - LOG)
Step ID        1
Server        MGHRORAYSQL\RAYCLINICAL
Job Name        DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH PREVIOUS - LOG
Step Name        DatabaseBackup - USER_DATABASES - LOG
Duration        00:00:02
Sql Severity    0
Sql Message ID    0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted    0
Message
Executed as user: NT Service\SQLAgent$RAYCLINICAL. ...rsion: 11.0.7001.0 Edition: Standard Edition (64-bit) Platform: Windows Procedure: [master].[dbo].[DatabaseBackup] Parameters: @databases = 'RayStationClinicDB_503_MGH_Q2_2017, RayStationMachineDB_502_MGH_Q4_2016, RayStationPatientDB_502_MGH_Q4_2016_Tegile, RayStationPatientDB_502_MGH_Q1_2017_Tegile, RayStationPatientDB_502_MGH_Q2_2017_Tegile, RayStationPatientDB_503_MGH_Q3_2017_Tegile, RayStationPatientDB_503_MGH_Q1_2018_Tegile_KL, RayStationPatientDB_503_MGH_Q2_2018, RayStationPatientDB_503_MGH_Q3_2018, RayStationPatientDB_503_MGH_Q4_2018, RayStationPatientDB_503_MGH_Q1_2019_BASE', @Directory = 'Z:\RAYSTATION_BACKUPS', @BackupType = 'LOG', @verify = 'Y', @CleanupTime = 48, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @FileName = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${Availabil... Version: 2018-07-16 18:32:21 Source: https://ola.hallengren.com Msg 50000, Level 16, State 1, Server MGHRORAYSQL\RAYCLINICAL, Procedure DatabaseBackup, Line 1402 The following databases in the @databases parameter do not exist: [RayStationPatientDB_503_MGH_Q1_2019_BASE]. Date and time: 2019-01-31 16:00:00 Database: [RayStationClinicDB_503_MGH_Q2_2017] Status: ONLINE Standby: No Updateability: READ_WRITE User access: MULTI_USER Is accessible: Yes Recovery model: FULL Encrypted: No Differential base LSN: 679000000027800038 Last log backup LSN: 679000000073100001 Date and time: 2019-01-31 16:00:00 Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'Z:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q2_2017\LOG' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:00:00 Date and time: 2019-01-31 16:00:00 Command: BACKUP LOG [RayStationClinicDB_503_MGH_Q2_2017] TO DISK = N'Z:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q2_2017\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_MGH_Q2_2017_LOG_20190131_160000.trn' WITH CHECKSUM, NO_COMPRESSION Processed 1 pages for database 'RayStationClinicDB_503_MGH_Q2_2017', file 'RayStationClinicDB_25189_log' on file 1. BACKUP LOG successfully processed 1 pages in 0.016 seconds (0.091 MB/sec). Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:00:00 Date and time: 2019-01-31 16:00:00 Command: RESTORE VERIFYONLY FROM DISK = N'Z:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q2_2017\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_... Process Exit Code 1. The step failed.
Can a fresh set of eyes take a look, and provide feedback?
Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

kaplan71 - Thursday, January 31, 2019 2:26 PM
Hello --
Two backup jobs for the log files on our server started failing this afternoon. I have been going over the log files, and I have not been able to determine what is the root cause.
The error log for the first job is the following:
Date        1/31/2019 4:11:41 PM
Log        Job History (DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH CURRENT - LOG)
Step ID        1
Server        MGHRORAYSQL\RAYCLINICAL
Job Name        DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH CURRENT - LOG
Step Name        DatabaseBackup - USER_DATABASES - LOG
Duration        00:00:04
Sql Severity    0
Sql Message ID    0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted    0
Message
Executed as user: NT Service\SQLAgent$RAYCLINICAL. ...rsion: 11.0.7001.0 Edition: Standard Edition (64-bit) Platform: Windows Procedure: [master].[dbo].[DatabaseBackup] Parameters: @databases = 'RayStationClinicDB_503_MGH_Q4_2018, RayStationClinicDB_503_MGH_Scripting_Tegile, RayStationMachineDB_503_MGH_Q1_2018, RayStationPatientDB_503_MGH_scripting, RayStationPatientDB_503_MGH_Q1_2019', @Directory = 'H:\RAYSTATION_BACKUPS', @BackupType = 'LOG', @verify = 'Y', @CleanupTime = 48, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @FileName = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${AvailabilityGroupName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @FileExtensionFull = NULL, @FileExtensionDiff = NULL, @FileExtensionLog = NULL, @Init = 'N', @DatabaseOrder = NULL, @Da... Version: 2018-07-16 18:32:21 Source: https://ola.hallengren.com Msg 50000, Level 16, State 1, Server MGHRORAYSQL\RAYCLINICAL, Procedure DatabaseBackup, Line 1402 The following databases in the @databases parameter do not exist: [RayStationPatientDB_503_MGH_scripting]. Date and time: 2019-01-31 16:11:41 Database: [RayStationClinicDB_503_MGH_Q4_2018] Status: ONLINE Standby: No Updateability: READ_WRITE User access: MULTI_USER Is accessible: Yes Recovery model: FULL Encrypted: No Differential base LSN: 615000000214000037 Last log backup LSN: 615000000253900001 Date and time: 2019-01-31 16:11:41 Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'H:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q4_2018\LOG' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:11:41 Date and time: 2019-01-31 16:11:41 Command: BACKUP LOG [RayStationClinicDB_503_MGH_Q4_2018] TO DISK = N'H:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q4_2018\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_MGH_Q4_2018_LOG_20190131_161141.trn' WITH CHECKSUM, NO_COMPRESSION Processed 1 pages for database 'RayStationClinicDB_503_MGH_Q4_2018', file 'RayStationClinicDB_25189_log' on file 1. BACKUP LOG successfully processed 1 pages in 0.004 seconds (0.366 MB/sec). Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:11:41 Date and time: 2019-01-31 16:11:41 Command: RESTORE VERIFYONLY FROM DISK = N'H:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q4_2018\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_MGH... Process Exit Code 1. The step failed.
The error log for the second job is shown below:
Date        1/31/2019 4:00:00 PM
Log        Job History (DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH PREVIOUS - LOG)
Step ID        1
Server        MGHRORAYSQL\RAYCLINICAL
Job Name        DatabaseBackup - USER_DATABASES - RAYSTATION 5 MGH PREVIOUS - LOG
Step Name        DatabaseBackup - USER_DATABASES - LOG
Duration        00:00:02
Sql Severity    0
Sql Message ID    0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted    0
Message
Executed as user: NT Service\SQLAgent$RAYCLINICAL. ...rsion: 11.0.7001.0 Edition: Standard Edition (64-bit) Platform: Windows Procedure: [master].[dbo].[DatabaseBackup] Parameters: @databases = 'RayStationClinicDB_503_MGH_Q2_2017, RayStationMachineDB_502_MGH_Q4_2016, RayStationPatientDB_502_MGH_Q4_2016_Tegile, RayStationPatientDB_502_MGH_Q1_2017_Tegile, RayStationPatientDB_502_MGH_Q2_2017_Tegile, RayStationPatientDB_503_MGH_Q3_2017_Tegile, RayStationPatientDB_503_MGH_Q1_2018_Tegile_KL, RayStationPatientDB_503_MGH_Q2_2018, RayStationPatientDB_503_MGH_Q3_2018, RayStationPatientDB_503_MGH_Q4_2018, RayStationPatientDB_503_MGH_Q1_2019_BASE', @Directory = 'Z:\RAYSTATION_BACKUPS', @BackupType = 'LOG', @verify = 'Y', @CleanupTime = 48, @CleanupMode = 'AFTER_BACKUP', @Compress = NULL, @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'Y', @BlockSize = NULL, @BufferCount = NULL, @MaxTransferSize = NULL, @NumberOfFiles = NULL, @CompressionLevel = NULL, @Description = NULL, @Threads = NULL, @Throttle = NULL, @Encrypt = 'N', @EncryptionAlgorithm = NULL, @ServerCertificate = NULL, @ServerAsymmetricKey = NULL, @EncryptionKey = NULL, @ReadWriteFileGroups = 'N', @OverrideBackupPreference = 'N', @NoRecovery = 'N', @URL = NULL, @Credential = NULL, @MirrorDirectory = NULL, @MirrorCleanupTime = NULL, @MirrorCleanupMode = 'AFTER_BACKUP', @MirrorURL = NULL, @AvailabilityGroups = NULL, @Updateability = 'ALL', @AdaptiveCompression = NULL, @ModificationLevel = NULL, @LogSizeSinceLastLogBackup = NULL, @TimeSinceLastLogBackup = NULL, @DataDomainBoostHost = NULL, @DataDomainBoostUser = NULL, @DataDomainBoostDevicePath = NULL, @DataDomainBoostLockboxPath = NULL, @DirectoryStructure = '{ServerName}${InstanceName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @AvailabilityGroupDirectoryStructure = '{ClusterName}${AvailabilityGroupName}{DirectorySeparator}{DatabaseName}{DirectorySeparator}{BackupType}_{Partial}_{CopyOnly}', @FileName = '{ServerName}${InstanceName}_{DatabaseName}_{BackupType}_{Partial}_{CopyOnly}_{Year}{Month}{Day}_{Hour}{Minute}{Second}_{FileNumber}.{FileExtension}', @AvailabilityGroupFileName = '{ClusterName}${Availabil... Version: 2018-07-16 18:32:21 Source: https://ola.hallengren.com Msg 50000, Level 16, State 1, Server MGHRORAYSQL\RAYCLINICAL, Procedure DatabaseBackup, Line 1402 The following databases in the @databases parameter do not exist: [RayStationPatientDB_503_MGH_Q1_2019_BASE]. Date and time: 2019-01-31 16:00:00 Database: [RayStationClinicDB_503_MGH_Q2_2017] Status: ONLINE Standby: No Updateability: READ_WRITE User access: MULTI_USER Is accessible: Yes Recovery model: FULL Encrypted: No Differential base LSN: 679000000027800038 Last log backup LSN: 679000000073100001 Date and time: 2019-01-31 16:00:00 Command: DECLARE @ReturnCode int EXECUTE @ReturnCode = [master].dbo.xp_create_subdir N'Z:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q2_2017\LOG' IF @ReturnCode <> 0 RAISERROR('Error creating directory.', 16, 1) Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:00:00 Date and time: 2019-01-31 16:00:00 Command: BACKUP LOG [RayStationClinicDB_503_MGH_Q2_2017] TO DISK = N'Z:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q2_2017\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_MGH_Q2_2017_LOG_20190131_160000.trn' WITH CHECKSUM, NO_COMPRESSION Processed 1 pages for database 'RayStationClinicDB_503_MGH_Q2_2017', file 'RayStationClinicDB_25189_log' on file 1. BACKUP LOG successfully processed 1 pages in 0.016 seconds (0.091 MB/sec). Outcome: Succeeded Duration: 00:00:00 Date and time: 2019-01-31 16:00:00 Date and time: 2019-01-31 16:00:00 Command: RESTORE VERIFYONLY FROM DISK = N'Z:\RAYSTATION_BACKUPS\MGHRORAYSQL$RAYCLINICAL\RayStationClinicDB_503_MGH_Q2_2017\LOG\MGHRORAYSQL$RAYCLINICAL_RayStationClinicDB_503_... Process Exit Code 1. The step failed.
Can a fresh set of eyes take a look, and provide feedback?
Thanks.

Your using Ola Hallengren scripts and passing in the databases to be backed up.
The errors are in there beginning with "The following databases in the @databases parameter do not exist:"
In the first job it could not find the database:
[RayStationPatientDB_503_MGH_scripting]
In the second job it could not find the database:
[RayStationPatientDB_503_MGH_Q1_2019_BASE]

Sue

kaplan71 Hall of Fame Points: 3634 More actions · Answer 2

Hello --

Thank-you for your reply. It turns out one of the other administrators deleted the databases in question, and neglected to tell me. I have reconfigured the jobs, and both are now completing successfully.

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 3

kaplan71 - Friday, February 1, 2019 7:50 AM
Hello --
Thank-you for your reply. It turns out one of the other administrators deleted the databases in question, and neglected to tell me. I have reconfigured the jobs, and both are now completing successfully.

Did "reconfigured the jobs" include testing to see if a database exists and reporting it if it doesn't. If not, you're not done fixing the jobs because it's going to happen again. The jobs should also automatically report any new databases.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)