Do you have idea on replication ?

Question

Accepted Answer

Yes, replication is the process of copying and distributing data from one database to another.

Replication is used to improve data availability, scalability, and disaster recovery.
It involves a publisher database that sends data to one or more subscriber databases.
There are three types of replication: snapshot, transactional, and merge.
Snapshot replication copies the entire database to the subscriber.
Transactional replication sends only the changes made to the database since the last replication.
Merge replication combines changes made at both the publisher and subscriber databases.
Replication can be configured to occur in real-time or on a schedule.
SQL Server provides tools for monitoring and troubleshooting replication issues.

Accepted Answer

Replication is nothing but making copy of your data and put it on different locations to achieve High availability and specially in sql server, there are 3 types of replication

Snapshot
Merge
Transactional

Do you have idea on replication ?

Top DXC Technology MS SQL DBA interview questions & answers

Popular interview questions of MS SQL DBA

Top HR questions asked in DXC Technology MS SQL DBA