Hello --

I ran sqlbuddy123's script, and the output, going back to February 22, is shown below:

DbNameBackupTypeBackupSize_MBBackupSize_GBBackup_StartDateBackup_EndDateBackupNameBackupDescriptionUserNameTakingBackupServerNameMachineNameDeviceName

RayStationClinicDB_4014L1.060.002014-03-19 10:00:02.0002014-03-19 10:00:02.000RayStationClinicDB_4014_backup_2014_03_19_100002_2892091NULLsaMGHROSTOR3\RAYCLINICALMGHROSTOR3T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_100002_2892091.trn

RayStationClinicDB_4014L1.060.002014-03-19 09:00:03.0002014-03-19 09:00:04.000RayStationClinicDB_4014_backup_2014_03_19_090003_4899012NULLsaMGHROSTOR3\RAYCLINICALMGHROSTOR3T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_090003_4899012.trn

RayStationClinicDB_4014L1.060.002014-03-19 08:00:02.0002014-03-19 08:00:05.000RayStationClinicDB_4014_backup_2014_03_19_080002_4397618NULLsaMGHROSTOR3\RAYCLINICALMGHROSTOR3T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_080002_4397618.trn

RayStationClinicDB_4014L1.060.002014-03-19 07:00:02.0002014-03-19 07:00:03.000RayStationClinicDB_4014_backup_2014_03_19_070002_2298332NULLsaMGHROSTOR3\RAYCLINICALMGHROSTOR3T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_070002_2298332.trn

RayStationClinicDB_4014L1.060.002014-03-19 06:00:02.0002014-03-19 06:00:03.000RayStationClinicDB_4014_backup_2014_03_19_060002_6448860NULLsaMGHROSTOR3\RAYCLINICALMGHROSTOR3T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_060002_6448860.trn

RayStationClinicDB_4014L1.060.002014-03-19 05:00:03.0002014-03-19 05:00:06.000RayStationClinicDB_4014_backup_2014_03_19_050002_1068238NULLsaMGHROSTOR3\RAYCLINICALMGHROSTOR3T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_050002_1068238.trn

RayStationClinicDB_4014L1.060.002014-03-19 04:00:03.0002014-03-19...

I checked the ERRORLOG file on the database server, and I found the following entries at the date and time specified in your posting:

2014-03-10 19:00:35.35 spid61 ...

It looks like one of the One Time Full Backup maintenance plans is the culprit. Both are set to run at 1:00 in the morning. However neither is enabled, and...

Hello --

I reran the script with the additions listed in your posting, and here are the results:

physical_device_namebkSizeTimeTakenbackup_start_datefirst_lsnlast_lsnBackupTypeserver_namerecovery_model

T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_080002_4397618.trn1 MB3 Seconds2014-03-19 08:00:02.0007700000000810000177000000008100001Transaction LogMGHROSTOR3\RAYCLINICALFULL

T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_070002_2298332.trn1 MB1 Seconds2014-03-19 07:00:02.0007700000000810000177000000008100001Transaction LogMGHROSTOR3\RAYCLINICALFULL

T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_060002_6448860.trn1 MB1 Seconds2014-03-19 06:00:02.0007700000000810000177000000008100001Transaction LogMGHROSTOR3\RAYCLINICALFULL

T:\BACKUP\RayStationClinicDB_4014_backup_2014_03_19_050002_1068238.trn1 MB3...

Hi --

Sorry to have to ask, but where would I change the syntax to have the script run on a database that is subject to the Full and Differential backups?

Thanks.

Hello --

I ran the script provided in your posting on the server, and the results are shown below:

master{77661EF0-2CBD-43C4-8E72-1E1CABD74B71}233 MB15 Seconds2014-03-17 19:00:36.000258000000039200072258000000043200001Full

masterT:\BACKUP\Full and Differential Backups\master_backup_2014_03_15_220002_0323294.bak3 MB3 Seconds2014-03-15 22:00:02.000256000000019200072256000000023200001Full

masterT:\BACKUP\Full and Differential Backups\master_backup_2014_03_13_010002_5590828.bak3...

Hello --

The problem that I reported has occurred again, even though I modified the Maintenance clean up to remove files that were older than two weeks. I checked the Maintenance...

I believe that I found the problem: Somehow the Maintenance Cleanup had been set to 2 days as opposed to 2 weeks. I changed the setting to reflect the larger...

Hi --

I had one follow-up question. If I wanted to change the subject, and the job run line within the e-mail notification, can I simply rename the backup plan, and/or...

Hello --

I believe I found the cause of the problem. When I checked the profile within the wizard, I noticed there were two entries. One was the correct one, the...

Hello --

Thanks for your reply. I checked the SQL Agent Error Logs, and I came across the following entries:

Date3/4/2014 1:29:25 PM

LogSQL Server Agent (Archive #1 - 3/5/2014 8:57:00 AM)

Message

[260] Unable...

Hi --

My apologies for my late response. I went ahead with your suggestion, and it worked. Thanks again for the help.

Let's try this again:

USE [msdb]

GO

/****** Object: Job [RayStation 25 Transaction Log Backup] Script Date: 02/20/2014 09:50:30 ******/

BEGIN TRANSACTION

DECLARE @ReturnCode INT

SELECT @ReturnCode = 0

/****** Object: JobCategory...

Per your request, I am posting the T-SQL scripts for the job in question:

Taken from the Maintenance Plan -> Backups -> Subplan_3

BACKUP LOG [RayStationClinicDB_25189] TO DISK = N'T:\BACKUP_25\RayStationClinicDB_25189_backup_2014_02_20_091754_5984039.trn' WITH...

Hello --

I went to the job in question, and in the Properties window, I went to Notifications. The settings are the following:

E-Mail <Operator> When job fails