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)