1. replication types and jobs 2. Transitional replication how it's work and which job run and what's is important

Question

Accepted Answer

Replication types and jobs, and how transactional replication works

Replication types include snapshot, transactional, and merge
Snapshot replication copies the entire database at a specific point in time
Transactional replication copies changes as they occur
Merge replication combines changes from multiple sources
Transactional replication uses a distributor to send changes to subscribers
Important jobs for transactional replication include the Log Reader Agent and Distribution Agent
The Log Reader Agent reads the transaction log and sends changes to the distribution database
The Distribution Agent moves changes from the distribution database to the subscriber
Transactional replication is important for maintaining data consistency across multiple databases

Popular interview questions of SQL Database Administrator