I have just started with a compny which has let their Transaction Log ballon to a riduculous level 305 GB for a !.5 GB Catalog.
The backups have been in FULL mode not SIMPLE
The Database was participating in a replication environment.
PUSH replication from a Master Distributed Database
1 Publisher , 3 Subscribers.
One of the Other subscribers - has a trans log of 38 GB.... still bloated in my mind but livable.
What would you recommend to get the Transaction Log to a reasonable level.
Could a person do a detach and reaatach with a new log file ignoring the bloated 305 gb log.