I have 3 requirements
1. Database log by default cleaned up for every 30 days. Can I retain or extend it??
2. Need to retain the last latest record for each table in Database log and prevent from automatic clean up after 30 days.
Suppose 30 changes are made to Method of payment table , which creates 30 records in database log . As per default 30 records are been deleted when automatic database log clean up is done, but I need to keep latest record in table instead of deleting all records. How can I achieve this?
3. Can we maintain of copy of Database log in to other table??