script for checking db backup

Hello,

I look for a script sql server allowing me to generate an error message when a base was never backup or when the full backup dates more than seven days.

Thanks

bibi
bibi92Asked:
Who is Participating?
 
DcpKingConnect With a Mentor Commented:
Take a look at the script here:
http://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/
It'll get you most of the info so you can incorporate the ideas into your scripts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.