Why aren't all my user databases logs being backed up?
I've got a maintenance job set up in SQL Server to backup all of my user databases and logs. Recently I downloaded and created an instance of the AdventureWorks database. The database is being backed up, but the logs aren't. Why is that? I would have thought that, because it is a user database, it would automatically be picked up, but it doesn't look that way.
Please check to see what recovery model is set for the database. I am guessing it will be set to SIMPLE, meaning no transaction log backups can be created (uncomment the last line of code to find out just about the Adventureworks database: SELECT name, recovery_model_desc FROM sys.databases D -- WHERE name = 'Adventureworks'
Double check the maintenance task and make sure you didn't manually select which DB's and logs to backup. If it is selected all user databases it should grab it, also check the recovery model of adventureworks.