I have a situation where storage was ripped out from under SQL Server. After running BBCC CheckDB I have received an "Extent (1:269886) in database ID 34 is allocated by more than one allocation object" message.
The research I have done basically tells me recover from backup. However, this table is a subscriber in transactional replication. Replication is set up such that I have added individual articles in the past in order to initialize in stages. Am I correct that I can do the following:
- Remove the article from replication
- Add the article back
- Let the agent job take a new snapshot
- Let that snapshot apply
Do I need to truncate or drop the damaged table first?
SQL Server 2008R2 on Windows Server 2008