In SQL Server 2005, log_reuse_wait_desc column in sys.databases system table is showing as Replication and you are getting alerts that your Tlog is full, how do you resolve this?
A. Update the column to Nothing and take Tlog backup
B. Temporarily stop/disable the Replication, increase the Log file size
C. Restart SQL Service
D. Take Tlog backup
Answer:B
In SQL Server 2005, log_reuse_wait_desc column in sys.databases system table is showing as Replication and you are getting alerts that your Tlog is full, how do you resolve this?
A. Update the column to Nothing and take Tlog backup B. Temporarily stop/disable the Replication, increase the Log file size C. Restart SQL Service D. Take Tlog backup