HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Is my Publisher database my actual source database or is it a new database?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
newactualsourcedatabasepublisher

Problem

I am setting up transactional replication for the first time and am working through my backup policies I need to set.

Is my Publisher database my actual source database? Or is it a new database that gets created when I create the new publication?

I know our production database is currently backed up regularly, Im not sure if I also need to back up the 'Publication` as well once it is created?

Solution

Yes, your publication database is your source database.

There are some considerations when backing up the publication database, as well as other replicated databases, such as the distribution and subscription databases. This is covered in Strategies for Backing Up and Restoring Snapshot and Transactional Replication.

Context

StackExchange Database Administrators Q#58691, answer score: 2

Revisions (0)

No revisions yet.