--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done, it will let you shrink the log file.
exec sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset = 1;
--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
--disable cdc master --Table Contains list of all the tables where cdc needs to be disabled - [dba].dbo.replication_cdc_table --execute...
Comments