Is it possible to delete data from a read only standby database that imports shipped log files?
At least in my theory this shouldn't be possible because the deletion would change the LSN and the log shipping should break.
What I need is a smaller sized database than the database that ships the logs. So basically I need a way to have the (readonly) standby server storing only the most recent data. Any ideas or recommendations on this?