January 31, 2019 at 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 0Message
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 0Message
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.
January 31, 2019 at 5:54 pm
kaplan71 - Thursday, January 31, 2019 2:26 PMHello --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 0Message
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 0Message
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
February 1, 2019 at 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.
February 3, 2019 at 5:42 pm
kaplan71 - Friday, February 1, 2019 7:50 AMHello --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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply