0

I have a strange problem, the transaction log for my database is being backed up however it is not selected.

I change the names of the server and databases in the screenshots to protect my information from the bad guys. ;)

Here is the issue that server "XYZ" is having, the screen shot below is showing the sub-plan for the "Transaction Log Backup" maintenance job. As you can see here "Database2" is showing up in the plan task.

Plan task

However in the properties plan task "Database2" is not selected. In order for the transaction log to be backed up the database has to be selected, like "Database1", right?

enter image description here

Despite the fact that "Database2" is not selected the transaction log is being backed up. I verified the properties of the database when the last transaction log was done.

So, I am a little confused about this and would like to know if anyone else here came across this and how you resolved it.

Server specs: SQL Server 2008 SP2 running on Windows Server 2008 R2 Standard

3

Your radio button is on All user databases and NOT on These Databases

  • Yep. The checkboxes are ignored if the radio button is set elsewhere. – BradC Feb 16 '17 at 18:43
  • I sent the wrong screen shot, the original screen shot has "These databases" selected. I was experimenting to see if I changed the setting if that would resolve this issue. The transaction log for this database is still backed up even thou the database is not selected. – user36578 Feb 16 '17 at 19:10
  • Are you 100% sure that THIS maintenance plan is the one creating the transaction log backups for Database2? How are you determining that the transaction log for Database2 is being backed up? Are you running a script against MSDB? If so, can you post the script your running? Also, when you're in the maintenance plan wizard and double click on the Backup Database task, try clicking View T-SQL - what do you see? – Scott Hodgin Feb 16 '17 at 19:22
  • Can you create another maintenance plan choosing only database1, test it out and delete the current one if the new maint plan does what you want? – Scott Hodgin Feb 16 '17 at 19:42
  • 1
    This is why I use backup scripts that aren't part of maintenance plans. Like those from ola.hallengren.com -- that way I know what's going on under the GUI. – CaM Feb 16 '17 at 21:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.