May 11, 2016

Find out When the Last Full Backup was Taken

The following query shows the last time a full backup was taken on a certain database. select database_name as [Database], [NameOfBackup], user_name as [BackupTakenBy],backup_start_date, backup_finish_date, backup_size as [SizeOfBackup], is_copy_only,has_backup_checksums, b.physical_device_name as [LocationOfBackup]from msdb.dbo.backupset a inner join msdb.dbo.backupmediafamily b on a.media_set_id=b.media_set_idwhere backup_set_id in(select max(backup_set_id) from msdb.dbo.backupset where type=’D’ and is_copy_only

HPE Launches IoT Platform

At the IoT/AppsWorld Conference, Hewlett-Packard Enterprise (HPE) unveiled its new Universal Internet of Things (IoT) Platform. The new solution aims to simplify management of multiple IoT tools. “Typically, the type of customers we are involved with have already been working in IoT to some level or another,” explained Nigel Upton,