MSSQLTips Monday Mission – Identify Missing Backups

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Simplify Data Merging in Power BI with DAX NATURALINNERJOIN]( The need to merge tables when developing Power BI solutions is a fundamental task. In Power BI, DAX offers a powerful function, NATURALINNERJOIN, to streamline this task, making the process of combining data using DAX easier. ... [Read Now]( [mssqltips image]( [SQL Server Maintenance Tasks You Probably Aren't Doing]( This webinar will cover a series of SQL Server maintenance items that are much less popular, but still important and should be a part of all DBAs maintenance and monitoring tasks.... [Read Now]( [mssqltips image]( [Monitor SQL Server Performance and Daily Operations]( Learn about dbWatch the Swiss army knife for DBAs. It's an all-in-one instance-level monitoring tool that can track backups, uptime, disk space, and one of my favorite things, performance, for every instance in your farm.... [Read Now]( TODAY'S SCRIPT ON MSSQLTips MSSQLTips Monday Mission - Identify Missing Backups On MSSQLTips, our goal is to help you best manage your Microsoft Data Platform - on-prem, in a data center or in the cloud. SQL Server database backups are one of those processes that are setup and often forgotten. However, we all know the criticality of up-to-date database backups when an unexpected issue arises. It is unfortunate when a bad situation turns into a catastrophe when good backups don’t exist when you most need them. Today's mission, should you choose to accept it, is to validate you’re not missing SQL Server backups for your databases. --Databases with last backup over 24 hours old SELECT CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server, msdb.dbo.backupset.database_name, MAX(msdb.dbo.backupset.backup_finish_date) AS last_db_backup_date, DATEDIFF(hh, MAX(msdb.dbo.backupset.backup_finish_date), GETDATE()) AS [Backup Age (Hours)] FROM msdb.dbo.backupset WHERE msdb.dbo.backupset.type = 'D' GROUP BY msdb.dbo.backupset.database_name HAVING (MAX(msdb.dbo.backupset.backup_finish_date) 'tempdb' ORDER BY msdb.dbo.backupset.database_name Learn more and share your feedback: [Script to retrieve SQL Server database backup history and no backups]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [SQL Server Stored Procedure Tutorial]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes.... [Read Now]( [mssqltips image]( [Universal Data Integration Tools - On-Prem and Cloud]( Universal real-time data integration is a serious technical and organizational challenge that supersedes the native SQL Server capabilities. CData has recognized these challenges and has delivered a universal data access solution via drivers for on-p... [Read Now]( [mssqltips image]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequent... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]