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.
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?
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