That is correct, and my apologies for the confusion. I have the Maintenance Plan created, and there are jobs under SQL Agent. The Maintenance Plan consists of the Full, Differential,...

The "work area" of the Studio has only one task box. This is the actual backup of the transaction logs. There is no additional box in the area referencing the...

Hello --

I am working with the Maintenance Plan Wizard within the SQL Studio application, and I have access to the Maintenance Plan Task -> Notify Operator Task option. I...

Hello --

Thank-you for your reply. As you requested, the T-SQL code for the Transaction Log Backups are listed below:

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

Hello --

I had a follow-up. I saved the output of the file to an rpt file, but I am hoping to generate a file similar to that which is shown...

Hello --

I went through the properties of the database within the Studio, and one idea that I had was to have the Change Tracking option set to True for the...

Hello --

I was doing further research into this issue over the weekend, and I came across Change Data Capture (CDC). Here is the information that I found about it:

Change Data...

Hello --

The data that has been entered into fields and tables of the database in question is, for the most part, static. There should not be any unexpected modifications to...

Hello --

I am open to using T-SQL as an option. I am not very adept at T-SQL so if you could provide the general syntax that would be used, I...

Hello --

Thanks for your reply. I am doing a comparison of the database to a date where it is determined the information that is present in the database has been...

Hello --

Thanks for everyone's help. The issue was neither the Enable Mail Profile or Fail-Safe Operator options were enabled for the agent. Once those were set, and the agent restarted,...

Hello --

The problem continues to occur even though the email address was corrected, and the SQL Agent was restarted on the server. I checked the history of the most recent...

Hello --

Thanks for the replies. I'm glad the incorrect email address was not a show-stopper in this scenario. I checked the SQL and and Application log files, and there was...

Hello --

I checked through the settings, and it appears the problem was the spelling of the email address was incorrect. I made the change, and will restart the SQL Agent...

Hello --

Thank-you for the replies. My intention is NOT to shrink the database. Rather, it is to allow it to expand. I had an idea about approaching this after I...