I am going over the concepts of Distributed database management system. I read about duplication and replication. Then there is also something called Mirroring. I googled to find if duplication is the same as mirroring but could not find. Are they same?

How is duplication different from snapshot replication?

closed as unclear what you're asking by Max Vernon, Martin Smith, Michael Green, Andriy M, RolandoMySQLDBA Jun 12 '16 at 23:37

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Database duplication is like making a copy of the database at a single point of time. Any changes made after duplicating on source will not flow to the copy. Whereas in mirroring, the changes will flow depending on your configuration/settings. – karun_r Jun 11 '16 at 1:13
  • 1
    Your title asks something different than the question. Are you interested in mirroring or snapshot replication? What do you mean by "duplication" anyway. This isn't a term used to mean anything specific in SQL Server. Do you have a precise definition in mind? – Martin Smith Jun 11 '16 at 12:55

Duplicate Database

It is separate database contains all or subset of the data of Source Database.

Its purpose varies like:

  • Test backup/recovery procedure
  • Test upgrade of new release
  • Test effect of DB performance
  • Generate reports
  • Export data table and import in production environment if inadvertently dropped

Snapshot Replication

Here data is replicated at specified time by copying data changes from Source Database (Publisher) to receiving database (Subscriber)

Its purpose varies like:

  • If data change is infrequent
  • If database is of small size or data change occurs in large amount

Not the answer you're looking for? Browse other questions tagged or ask your own question.