Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2009-11-05 : 20:38:12
|
| Hello! I have removed replication on the server but log space is not being reclaimed because some of the transactions are still marked for replication:select log_reuse_wait_desc,* from sys.databases --shows REPLICATIONFollowing command doesn't work because database is no longer marked for replicationEXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1Database is in SIMPLE recovery mode. Any ideas how I can remove transactions marked for replication from the log?Thanks,Igor |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
|
|
|
|
|
Unable to remove transaction from the log