You should only use the Backup Log Truncate Only if you know you have a good backup of the currect db or if you are out of disk space and...

The replication is running fine, no issues are shown at all. Before the subscription to the transactional replication is created, the query runs quickly. After the subscription has been created...

The query is not being blocked. At the time i am trying it, i am the only user on the DB.

The problem occurs after the initial snapshot is applied on...

I have a similar situation and to lessen the load on the server, we have used the target server as the distributor and publisher. This means all the replication processes...

Also, you dont just drop a primary key without investigation. After all that key might be driving the most used query on the system.

The recovery mode is Bulk Logging.

I will try to run a manual backup later on today 15th Jan and come back with the results.

A new file is created each time. It is as part of a maintenance plan. The plan has the following set for the t log

Backup of the transaction log

Verify is...