I now, once again, been asked for lock-up, aging and KPI data as it was last year-end.
Obviously a well-behaved database administrator would take an end of year backup, but...
When a PE year is closed, could the system create an end-of-year SQL backup, name and number it intelligently, and store it somewhere.
Hi Eoin,
As the location for the backup file would need to be changed for each user I would probably see this as a client SP. You could add a database backup to the period end SP when it detects that it is a year end that is being run. That would allow you to specify the backup location to be somewhere that isn't going to cause problems for the badly behaved DBA.
