I have a client with a requirement that states data can only be retained for a certain amount of time. After the time expires, the data is deleted from the database and cannot be retained or available. While the data is no longer in the database,
it would still reside in a backup taken prior to the expiration. Is there any way to prevent a backup from being used to restore a database after a point in time. Using the Expiration Date or Days Retention, only specify the backup can be overwritten.
Is there any way at all to invalidate the backup after a period of time so that it can no longer be restored?
View Complete Post