Blog Archives

Alert – Databases do not have Transaction log backups

The SP below sends alert when there are no transaction log backups in the last 90 minutes.

Tagged with: ,
Posted in Alerts, Backup, Scripts

Estimated time of Backup / Restore [SQL Server]

Sometimes you will want to know how is the backup progress before a critical change of your environment or during the restore before setting a new high availability strategy. This script can help you to figure out.

Tagged with: , , ,
Posted in Backup, Scripts, SQL Server Tips

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

Tagged with: , ,
Posted in Administration, Backup