Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

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
0
bibi92
Asked:
bibi92
1 Solution
 
DcpKingCommented:
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

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now