Article Details
Id:13194
Product:finPOWER Connect
Type:NEW
Version:2.03.02
Opened:03/08/2015
Closed:27/08/2015
Released:01/09/2015
Job: J016012

SQL Server Databases; new functionality to test the date the last Backup was completed

There is a new Database provider function to get the last date and time a backup was run. Note, this is only supported by SQL Server databases.

Under User Preferences, General group, Database page, there is a new option to "Show backup warnings?". For SQL Server databases this is checked by default.

When opening a database, if the database has not been backed up for more than 3 days a warning is given. This is irrespective of weekends and public holidays.

The following Business Layer functions are available:

' Determine if the Database supports getting Backup information
finBL.Database.CurrentProviderUtilities.SupportsGetDatabaseLastBackupInformation

' Gets the last Backup information
finBL.Database.CurrentProviderUtilities.GetDatabaseLastBackupInformation(createdUtcDate, lastBackupUtcDate)