Hi All,
We have a database of Size 600 GB.
And there is a etl job that inserts huge chucks of records every one hour. And also we have transaction log backup every one hour too.
And the the insert statement was dynamically constructed and executed via sp_executesql
Is is possible these insert statement gets logged in transaction log. I am confused with that. Actually we have a situation to restore back few hours back log to see some of the data inserted?
Thank you.