Delete data from a MSSQL standby database?
- by SQL-Newbie
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…