I understand what you mean. I think

keeping online 12 years transaction is

such as unusual jobs.

But my customer requires this to be implemented: "Capability to show/create transaction data/report with 12 years retention".

If I create sql scrip to move data older than 1 year to stand by server and we backup the data then the customer has to restore the data before they can have the report they want.

Is there any other solution to this issue?

Thank You

-mayrobi-