“Backup and Restore Events” standard database report do not show all backup failure events

While investigating backup failure related issue on SQL SERVER 2008 R2 I was trying to pull the backup failure related information using “Backup and Restore Events” report however interestingly I don’t see any failure reported there. I went back and tried to reproduce the issue by taking a 10 GB database backup on 5 GB…

0

How to track inactive logins in SQL SERVER

Many customer asked me if there is any easy way to find the list of logins which are inactive and can be deleted hence thought of documenting this method using blog. You could go to SQL SERVER Property and then turn on “Successful logins only” to record login information in SQL SERVER ERRORLOG. It would…

2