sql server replication: Hi,
I am replicating a large table from the publisher to subscriber database using basic transaction replication. The subscriber is currently an exact copy of the publisher since they were originally synchonized. (The subscriber is used as a reporting database). The subscribing database is getting too large for the disc and I would like to delete a portion of the oldest data in the largest table. My question is: will deleting data in the subscriber table cause any error in the replication? I've never done this before and would not like to guess. Any help would be appreciated. Thanks
Don Salug
Database Administrator

Don,
as long as you're not using updating subscribers this is feasible. However,
transactions which refer to the deleted rows on the publisher will fail when
synchronised with the subscriber. As long as you can be sure they won't
refer to these rows then you're ok.
Regards,
Paul Ibison

Thank you Paul.
Yes, I agree with your logic. I was hoping to confirm this with some other expert before I actually delete the data. The data I will delete is event logs that have a primary key with the date and seqno so they won't ever be repeated. Thank you so much.

Have a nice day