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