The Young DBA

Last week I faced an error on testing environment while right click on my subscriber and article property.    ------------------------------ Database 'distribution' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information. (Microsoft SQL Server, Error: 926) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.5058&EvtSrc=MSSQLServer&EvtID=926&LinkId=20476 ------------------------------

Hey friends, I am filling good to write my 1st post in 2015. This is related to error in replication which i faced in 2014 he he. Last month i was facing an error during roll backing Transnational replication as below.. ------------------------------ Could not delete publication 'XXX'. Microsoft SQL Server, Error: 155 17 TITLE: Microsoft.SqlServer.ConnectionInfo

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process. To add an article In Transaction replication with PUSH Subscription