Tuesday, March 20, 2012

Post SP3 upgrade

I upgraded a server last night to SP3 and all of my push subscriptions
disappeared, but all the publications remained. When I go to recreate
them, the push subscriptions, I receive the following message...
Error 2812: Could not find stored rocedure
'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
Distributor or the distribution database for the local server. The
Distributir may not be installed, or the local server may not be
configured as a Publisher at the Distributor.
What does this mean? Can I create the push subscriptions?
TIA,
Larry...b
can you issue these queries for me?
select count(*) from master.dbo.sysobjects
go
select count(*) from distribution.dbo.sysobjects
go
Issue them in both the publisher and subscriber.
Hilary Cotter
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
<lreames@.gmail.com> wrote in message
news:1108496768.247604.52820@.z14g2000cwz.googlegro ups.com...
> I upgraded a server last night to SP3 and all of my push subscriptions
> disappeared, but all the publications remained. When I go to recreate
> them, the push subscriptions, I receive the following message...
> Error 2812: Could not find stored rocedure
> 'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
> Distributor or the distribution database for the local server. The
> Distributir may not be installed, or the local server may not be
> configured as a Publisher at the Distributor.
> What does this mean? Can I create the push subscriptions?
> TIA,
> Larry...b
>
|||on publisher
select count(*) from master.dbo.sysobjects --> 1265
select count(*) from distribution.dbo.sysobjects --> 63
on subscriber
select count(*) from master.dbo.sysobjects --> 1308
select count(*) from distribution.dbo.sysobjects --> 245
|||Oops wrong queries - although right now I strongly suspect you have had an
incomplete service pack deployment on your publisher. Can you post these
logs here:
%windir%\sqlsp.log
%windir%\sqlstp.log
Then post the results of these queries
on the publisher
select count(*) from master.dbo.sysobjects where type='p'
select count(*) from distribution.dbo.sysobjects where type='p'
select @.@.version
on the subscriber
select count(*) from master.dbo.sysobjects where type='p'
select count(*) from distribution.dbo.sysobjects where type='p'
select @.@.version
Please do not apply the sp on your subscriber again. Also do you have
backups of your master database over the past couple of days?
Hilary Cotter
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
<lreames@.gmail.com> wrote in message
news:1108498247.749656.228490@.f14g2000cwb.googlegr oups.com...
> on publisher
> select count(*) from master.dbo.sysobjects --> 1265
> select count(*) from distribution.dbo.sysobjects --> 63
> on subscriber
> select count(*) from master.dbo.sysobjects --> 1308
> select count(*) from distribution.dbo.sysobjects --> 245
>
|||can you also save the results of this query and post them here:
select name, crdate from sysobjects where type='p'
Hilary Cotter
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
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OMUZ8D9EFHA.1348@.TK2MSFTNGP14.phx.gbl...
> Oops wrong queries - although right now I strongly suspect you have had an
> incomplete service pack deployment on your publisher. Can you post these
> logs here:
> %windir%\sqlsp.log
> %windir%\sqlstp.log
> Then post the results of these queries
> on the publisher
> select count(*) from master.dbo.sysobjects where type='p'
> select count(*) from distribution.dbo.sysobjects where type='p'
> select @.@.version
> on the subscriber
> select count(*) from master.dbo.sysobjects where type='p'
> select count(*) from distribution.dbo.sysobjects where type='p'
> select @.@.version
> Please do not apply the sp on your subscriber again. Also do you have
> backups of your master database over the past couple of days?
> --
> Hilary Cotter
> 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
> <lreames@.gmail.com> wrote in message
> news:1108498247.749656.228490@.f14g2000cwb.googlegr oups.com...
>

No comments:

Post a Comment