Scenario
I have a transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration.
Solution
Let’s look at three different scenarios for renaming a database:
- Renaming the Publication Database
- Renaming the Publication Database Logical File Names
- Renaming the Publication Database Physical Files