Renaming a Published SQL Server Database

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 10 Apr 2012 06:00:00 UT Indexed on 2012/04/10 11:37 UTC
Read the original article Hit count: 196

Filed under:

I have 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.

SQL Backup Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

© SQL Server Central or respective owner