Wednesday, March 28, 2012

reg. Prob with replication

HI,
Im using Mssql 2000, We are migrating the server from one server to
another.
i will list out what i have done, so pls let me know what wrong i did
and how to solve.
1. install mssql s/w
2. restore master db
3. restore users db's.
4. Run the replication script (extracted from old server)
im getting the errors, as follows
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure
sp_MSupdate_agenttype_default, Line 12
Invalid object name 'msdb..MSagent_profiles'.
Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
Line 164
Invalid object name 'msdb..MSdistributiondbs'.
Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
Line
95
The server 'ADCPWSQLZ7' is already a Subscriber.
............
......
pls help me to solve the error.
thksIf you wanted a hope of getting this to work you should have restored the
msdb and distribution databases as well and then renamed the new server with
the name of the old server.
you need to disable replication and then recreate it and then try to re-run
your scripts on this server.
--
http://www.zetainteractive.com - Shift Happens!
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
"calms" <calmsqurill@.gmail.com> wrote in message
news:ddb85046-94b1-4e43-a006-f3d3a24bca5a@.s12g2000prg.googlegroups.com...
> HI,
> Im using Mssql 2000, We are migrating the server from one server to
> another.
>
> i will list out what i have done, so pls let me know what wrong i did
> and how to solve.
>
> 1. install mssql s/w
> 2. restore master db
> 3. restore users db's.
> 4. Run the replication script (extracted from old server)
>
> im getting the errors, as follows
>
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure
> sp_MSupdate_agenttype_default, Line 12
> Invalid object name 'msdb..MSagent_profiles'.
> Server: Msg 208, Level 16, State 1, Procedure sp_adddistributiondb,
> Line 164
> Invalid object name 'msdb..MSdistributiondbs'.
> Server: Msg 14040, Level 16, State 1, Procedure sp_addsubscriber,
> Line
> 95
> The server 'ADCPWSQLZ7' is already a Subscriber.
> ............
> ......
>
> pls help me to solve the error.
>
> thks
>

No comments:

Post a Comment