Tuesday, April 24, 2012

query to see if replication is preventing log record reuse

--  use the query to see if replication is preventing log record reuse.
--If the log_reuse_wait_desc column contains the value ‘REPLICATION’, replication is the reason for unexpected log growth.
select log_reuse_wait_desc, name from sys.databases

No comments:

Post a Comment