Current & Backedup database records out of sync problem
-
Hello, I have a database which is being backed up on daily bases. According to requirement, we need to remove records from database those are older than 30 days. This is working fine. But the problem is we are only able to delete old records from live database. This is to be noted that the same records has been already backed up before deleting. Now, due to security purpose, we need to remove the same old records from backed up database too. Restoring all old backups and and then deleting the records will not work as there are total 30 backups which contain the entry for the records to be deleted. Can you please provide me some suggestions regarding this requirement. Thanks.
-
Hello, I have a database which is being backed up on daily bases. According to requirement, we need to remove records from database those are older than 30 days. This is working fine. But the problem is we are only able to delete old records from live database. This is to be noted that the same records has been already backed up before deleting. Now, due to security purpose, we need to remove the same old records from backed up database too. Restoring all old backups and and then deleting the records will not work as there are total 30 backups which contain the entry for the records to be deleted. Can you please provide me some suggestions regarding this requirement. Thanks.
Lucky123456 wrote:
Restoring all old backups and and then deleting the records will not work as there are total 30 backups which contain the entry for the records to be deleted.
Think about this; how can you delete records from a database (or any type of file) without loading that file to disk and accessing it via some sort of software?
-
Lucky123456 wrote:
Restoring all old backups and and then deleting the records will not work as there are total 30 backups which contain the entry for the records to be deleted.
Think about this; how can you delete records from a database (or any type of file) without loading that file to disk and accessing it via some sort of software?
Thanks, I am googling for any option available.
-
Lucky123456 wrote:
Restoring all old backups and and then deleting the records will not work as there are total 30 backups which contain the entry for the records to be deleted.
Think about this; how can you delete records from a database (or any type of file) without loading that file to disk and accessing it via some sort of software?
Not able to find such method to read/modify a .bak file. Thinking about any alternate solution. :doh:
-
Not able to find such method to read/modify a .bak file. Thinking about any alternate solution. :doh:
-
Hello, I have a database which is being backed up on daily bases. According to requirement, we need to remove records from database those are older than 30 days. This is working fine. But the problem is we are only able to delete old records from live database. This is to be noted that the same records has been already backed up before deleting. Now, due to security purpose, we need to remove the same old records from backed up database too. Restoring all old backups and and then deleting the records will not work as there are total 30 backups which contain the entry for the records to be deleted. Can you please provide me some suggestions regarding this requirement. Thanks.
That is one of the weirdest business models I have EVER heard of (in 20+ years of hearing some really screwy ideas). A backup is NOT a data storage tool it is a RECOVERY tool, deleting data from a backup defeats the purpose of taking a backup. It is a snapshot of the database as at WHEN IT WAS BACKED UP. Expecting a backup to reflect the current data is just wrong.
Never underestimate the power of human stupidity RAH