Steps to restore distribution database and how to control transaction log of subscriber database in read only transactional replication
What are the steps required to restore distribution database backup in transactional replication. I have gone through all the microsoft documentation but could not find the steps to restore it. Please also suggest the situations when restore of distriubtion database is necessary.
Secondly, I am not taking backups of the subscriber database as it is being reinitialized from publisher in case of faliure. But, in this case how to keep transaction log growth in control? Should I rely on Shrink Database and rebuild/reorganize indexes process to keep it under control.
Your early reply in this regard would be greatly appreciated.
Thanks.
Secondly, I am not taking backups of the subscriber database as it is being reinitialized from publisher in case of faliure. But, in this case how to keep transaction log growth in control? Should I rely on Shrink Database and rebuild/reorganize indexes process to keep it under control.
Your early reply in this regard would be greatly appreciated.
Thanks.
Last Comment
ASKER
Can you please help with the 1st question.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks a lot JoeNuvo this has resolved the problem. Great Answer.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
for 1st question, I can't find the answer myself yet. Most likely, if restore distributor database, I might need to re-initial all subscriber. Since data which log reader already read, won't be read again from Publisher server.