cannot delete publication
in [Replication]
|
From: Sandeep Shankar on 30 Jul 2007 17:26 We are using SQL Server 2005 Service Pack 2 on WIn2003. We lost our distributor and I reinstall SQL Server in Distributor machine. Now I am not able to delete publication and subscription from publisher and subscriber. Any help highly appreciated. tried sp_removedbreplication Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 27 Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for replication. Thanks
From: Sandeep Shankar on 30 Jul 2007 17:58 Or I get following error OLE DB provider "SQLNCLI" for linked server "repl_distributor" returned message "Communication link failure". Msg 233, Level 16, State 1, Line 0 Named Pipes Provider: No process is on the other end of the pipe. "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message news:%23t%23jvCv0HHA.4236(a)TK2MSFTNGP06.phx.gbl... > We are using SQL Server 2005 Service Pack 2 on WIn2003. > > We lost our distributor and I reinstall SQL Server in Distributor machine. > Now I am not able to delete publication and subscription from publisher and > subscriber. > > Any help highly appreciated. > > > tried > sp_removedbreplication > > Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 27 > > Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for > replication. > > > > Thanks > >
From: Hilary Cotter on 31 Jul 2007 08:40 set the ignore_distributor =1 parameter -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message news:%234MijUv0HHA.4004(a)TK2MSFTNGP05.phx.gbl... > Or I get following error > > OLE DB provider "SQLNCLI" for linked server "repl_distributor" returned > message "Communication link failure". > > Msg 233, Level 16, State 1, Line 0 > > Named Pipes Provider: No process is on the other end of the pipe. > > > > > > > > > > "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message > news:%23t%23jvCv0HHA.4236(a)TK2MSFTNGP06.phx.gbl... >> We are using SQL Server 2005 Service Pack 2 on WIn2003. >> >> We lost our distributor and I reinstall SQL Server in Distributor >> machine. >> Now I am not able to delete publication and subscription from publisher > and >> subscriber. >> >> Any help highly appreciated. >> >> >> tried >> sp_removedbreplication >> >> Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line > 27 >> >> Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for >> replication. >> >> >> >> Thanks >> >> > >
From: Sandeep Shankar on 31 Jul 2007 12:03 I did put this parameter yesterday, but Now when I refresh 'Local Publication' I get ' Failed to retrive data for this request.' More info A exception occurred while executing a transact- sql statement or batch Lock request time out period exceeded Thanks "Hilary Cotter" <hilary.cotter(a)gmail.com> wrote in message news:OPzWNA30HHA.4184(a)TK2MSFTNGP06.phx.gbl... > set the ignore_distributor =1 parameter > > -- > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message > news:%234MijUv0HHA.4004(a)TK2MSFTNGP05.phx.gbl... > > Or I get following error > > > > OLE DB provider "SQLNCLI" for linked server "repl_distributor" returned > > message "Communication link failure". > > > > Msg 233, Level 16, State 1, Line 0 > > > > Named Pipes Provider: No process is on the other end of the pipe. > > > > > > > > > > > > > > > > > > > > "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message > > news:%23t%23jvCv0HHA.4236(a)TK2MSFTNGP06.phx.gbl... > >> We are using SQL Server 2005 Service Pack 2 on WIn2003. > >> > >> We lost our distributor and I reinstall SQL Server in Distributor > >> machine. > >> Now I am not able to delete publication and subscription from publisher > > and > >> subscriber. > >> > >> Any help highly appreciated. > >> > >> > >> tried > >> sp_removedbreplication > >> > >> Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line > > 27 > >> > >> Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for > >> replication. > >> > >> > >> > >> Thanks > >> > >> > > > > > >
From: Hilary Cotter on 1 Aug 2007 08:41 You are getting some deadlocking occurring. Run dbcc opentran and see if there are open transaction. evaluate whether you can kill them. Close down all instance of EM, stop the agents and try again. -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message news:ez9U3y40HHA.4652(a)TK2MSFTNGP05.phx.gbl... >I did put this parameter yesterday, but Now when I refresh 'Local > Publication' I get ' Failed to retrive data for this request.' > > More info > A exception occurred while executing a transact- sql statement or batch > Lock request time out period exceeded > > Thanks > > > > "Hilary Cotter" <hilary.cotter(a)gmail.com> wrote in message > news:OPzWNA30HHA.4184(a)TK2MSFTNGP06.phx.gbl... >> set the ignore_distributor =1 parameter >> >> -- >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message >> news:%234MijUv0HHA.4004(a)TK2MSFTNGP05.phx.gbl... >> > Or I get following error >> > >> > OLE DB provider "SQLNCLI" for linked server "repl_distributor" returned >> > message "Communication link failure". >> > >> > Msg 233, Level 16, State 1, Line 0 >> > >> > Named Pipes Provider: No process is on the other end of the pipe. >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > "Sandeep Shankar" <sandeeps(a)dntg.net> wrote in message >> > news:%23t%23jvCv0HHA.4236(a)TK2MSFTNGP06.phx.gbl... >> >> We are using SQL Server 2005 Service Pack 2 on WIn2003. >> >> >> >> We lost our distributor and I reinstall SQL Server in Distributor >> >> machine. >> >> Now I am not able to delete publication and subscription from >> >> publisher >> > and >> >> subscriber. >> >> >> >> Any help highly appreciated. >> >> >> >> >> >> tried >> >> sp_removedbreplication >> >> >> >> Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, > Line >> > 27 >> >> >> >> Cannot drop the table 'dbo.MSpeer_lsns' because it is being used for >> >> replication. >> >> >> >> >> >> >> >> Thanks >> >> >> >> >> > >> > >> >> > >
|
Pages: 1 Prev: cleanup msmerge_genhistory Next: Login Failed for user "Distributor_admin' |