patternMinor
Is my Publisher database my actual source database or is it a new database?
Viewed 0 times
newactualsourcedatabasepublisher
Problem
I am setting up
Is my
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?
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.
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.