By mistake I have deleted the repl_distributor server object, but now I need this for replication how can we re-add this. I tried to use below command for the same
EXEC master.dbo.sp_addlinkedserver @server = N'repl_distributor', @srvproduct=N'SQL Server'
it add repl_distributor to the server list but also point data_source to repl_distributor. Because of that I am getting error when I try to add some distributor using EXEC sp_adddistributor. It says
"The server 'repl_distributor' is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution
Please help me adding repl_distributor to the MSSQL Database 2008 enterprise edition.
Thanks in advance.
View Complete Post