NEW2.03.02 · Released 1 September 2015
NEWfinPOWER Connect
Released in
2.03.02
1 September 2015
  1. Opened3 Aug
  2. Closed27 Aug
  3. Released1 Sep
Article 13194 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)