How to find databases without transaction log backups [SQL Server]

In my previous post Last backup of all databases, I had sent a little tip to find details about status of last backup Full.
Here is a query to show you the databases that are in Bulk-Logged and Full Recovery model where there are a Full Backup without any transaction log backups.

Possible problems
Without log backups, the transaction logs will not be check-pointed. So, the spaces will not be reused causing high growth on logfiles.


SELECT            
'DB without transaction log bkps' [.],
D.[name] as [database], D.[recovery_model_desc] as [recovery_model],
BS1.[last_log_backup_date] ,BS2. [last_data_backup_date]
FROM            
(sys. databases D left outer JOIN             
(            
   SELECT BS .[database_name],                
   MAX( BS.[backup_finish_date] ) AS [last_log_backup_date]             
   FROM msdb .dbo. backupset BS
   INNER JOIN sys .sysdatabases sys on sys . name = BS . [database_name]  
   WHERE BS .type = 'L'
   GROUP BY BS. [database_name]             
   ) BS1             
ON D. [name] = BS1 .[database_name]            
LEFT OUTER JOIN             
(            
   SELECT BS .[database_name],              
   MAX( BS.[backup_finish_date] ) AS [last_data_backup_date]             
   FROM msdb .dbo. backupset BS
   INNER JOIN sys .sysdatabases sys on sys . name = BS . [database_name]  
   WHERE BS .type = 'D'
   GROUP BY BS. [database_name]             
 

Availability Groups Setup and Configuration from A to Z

AlwaysOn Availability Groups was introduced in SQL Server 2012, and it’s one of the most important features in the history of SQL Server.
The link provided below, as far as I’m concerned, it’s a complete step by step on how to configure a high availability solution with the Availability Groups.
There are points that you must consider before installation, as well as installing the hotfix KB2494036.
  • A hotfix is available to let you configure a cluster node that does not have quorum votes in Windows Server 2008 and in Windows Server 2008 R2

http://blogs.lessthandot.com/index.php/architect/availability-groups-setup-and-configuration-from-a-to-z/

Enjoy it!