NEW2.03.02 · Released 1 September 2015
NEWfinPOWER Connect
Released in
2.03.02
1 September 2015
- Opened3 Aug
- Closed27 Aug
- 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 informationfinBL.Database.CurrentProviderUtilities.SupportsGetDatabaseLastBackupInformation' Gets the last Backup informationfinBL.Database.CurrentProviderUtilities.GetDatabaseLastBackupInformation(createdUtcDate, lastBackupUtcDate)