Home > IT Answers > SQL Server > SQL Server replication fails after renaming Subscriber database
BrentSheets
6,580 pts.
 SQL Server replication fails after renaming Subscriber database
SQL Server 2005, SQL Server 2005 replication, SQL Server Publisher/Subscriber, SQL Server replication, Windows Server 2003
Running SQL Server 2005 on Windows Server 2003. Can the subscriber database to my publication be renamed? Experimented with renaming a test database but replication failed. Thanks. Moderator Note: This is a user submitted question

Software/Hardware used:
ASKED: March 13, 2009  6:08 PM
UPDATED: March 14, 2009  6:24 AM
RELATED QUESTIONS
Answer Wiki:
No, you can't rename the subscriber database. If you need to you can update the subscribers table in the distributor. You would also need to change the distribution job so that it has the new subscriber name.
Last Wiki Answer Submitted:  March 14, 2009  6:23 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _