The Backup Status tool monitors your SQL Server backup status, helping to make sure that you back up your SQL Servers on a regular basis. By default, Backup Status connects to the specified SQL Server instance using the credentials of your currently logged on Windows account, and then collects information about backups performed on the hosted databases.
The Backup Status tool helps you:
- Identify any non-backed up databases.
- Determine databases not backed up within the last x days.
- Determine which databases are in simple or full recovery mode.
- View the last backup time stamp for each database.
- Drill into the complete backup history for a specific database.
- View backup history across multiple SQL Server instances or a server group.
- Save the backup history.
Importance of backups and the Backup Status tool
Performing regular back ups of all databases on your SQL Server instances allows you to keep sensitive and mission-critical data safe. It is important that you determine your normal backup schedule. For example, if you want to back up all databases every week, you might want to skip databases backed up within the past seven days, allowing you to focus on databases with backup sets older than eight days. The Backup Status tool offers the following options when checking the backup status of an instance:
Skip databases with a backup in the last x days
Check this box for the Backup Status tool to exclude databases that include a backup performed in the past x number of days.
Skip system databases
Check this box for the Backup Status tool to exclude system database backups.
Only include full database backups
Check this box for the Backup Status tool to include only those databases that include a full database backup.
Exclude Offline Databases
Check this box for the Backup Status tool to exclude all offline databases from the backup status check.
Include all nodes
Check this box for the Backup Status tool to include all nodes in the backup status check.
Use the Backup Status tool
To check the backup status of one or move servers using the Backup Status tool:
- Open the IDERA SQL Admin Toolset Launchpad, and then click Backup Status.
- Specify whether you want to back up a SQL Server instance or a server group.
- Search for and then select the SQL Server instance or server group whose backup status you want to check. To specify multiple SQL Servers, separate each instance name with a semicolon.
- Optional. Check the options you want to use in this status check.
- Click Get Backup Status. The Backup Status tool checks the backup status of the appropriate instance or group.
- If you want to view the backup history for a specific database , select the database from the status list, and then click Show Backup History for Database.
- If the tool returns unexpected results , check the groom settings on the SQL Server instance. For example, if the backup operation status is recently groomed, the tool may return a partial history, such as a transaction log backup record with no corresponding full backup record.
- If you want to save the results , click Copy Results To Clipboard, or right-click to save the results in a data table, or as an XML or CSV file.