SQL Server Flashback Data
with very large database systems, backup and restore activity is challenging and many times logical errors can happen anytime especially with big critical systems.
when i say "logical errors", this means DML operation of update,delete,insert by mistake. in order to cover this operation in a very large database system will require performing a complete backup of the full database then differential, transaction log.....etc (the whole backup chain).
what i am proposing is a new "feature" to have a guaranteed transaction log (without truncation) and have the ability to use flashback capability to recover data quickly in-place without the need of the classical backup/restore operations.
Also, using flashback you can revert back T-SQL code where a procedure sql code was overwritten by mistake and you would like to recover to the original code quickly.