How to ensure that SQL Server databases are backed up on a regular basis

by Dec 10, 2020

Keep sensitive and mission-critical data safe by performing regular backups of all important databases.

  • Identify any non-backed up databases.
  • Determine which databases are not backed up within the last specified number of days.
  • Display the last backup time stamp for each database.
  • Drill down into the complete backup history for a specific database.
  • Display the history of backups across multiple instances or a server group.
  • Save the history of backups.

With the Backup Status tool of SQL Admin Toolset, check the status of backups of databases on SQL Server instances.

This is how easy it is:

  1. Connect to one or more instances.
  2. Specify the options:
    1. Skip databases that include a backup performed in the past specified number of days.
    2. Skip backing up system databases.
    3. Include only databases that include a full database backup.
    4. Exclude all offline databases from the backup status check.
  3. Display the status of the backups.
  4. Select a database to view its history of backups.
  5. Copy the results to the Windows Clipboard, and save the results as an XML and CSV text file.

Watch the video for more details:

https://youtu.be/UMmADIZbjxo

For SQL Admin Toolset:

Save almost 40% off the regular price when you purchase online. Take advantage of this limited time offer and pay only $253 per user with the first year of maintenance included! That is only $11 per tool! Hurry, this offer ends December 31th! Save Now!