25112
asked on
RESTORE to be possible only for a limited time
I want the backup to be valid only for one day.. so if someone tries to restore on 2nd day, it should say 'not possible- expired'..
but i am not sure EXPIREDATE/RETAINDAYS do that.. are there any other options?
but i am not sure EXPIREDATE/RETAINDAYS do that.. are there any other options?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could write a job/process that used the SQL backup history (in msdb) to follow up and delete any local backups made after (n) day(s).
ASKER
users ask for db backup.. its Ok.. but they are known for not deleting from their local machines or let it sit forever.. and hence cause security concern that someone not authorizaed will get it..if we make it expire it in ___ days, it puts some restraint...
any other tweaks that can be done?