replication is pending mode

hi guys,
Publication is in pending status. I don't know what is the problem.. I am using DOMAIN account(administrator). Publisher and subscriber are on same machine.
Error I got in my event viewer.
SQL Server Scheduled Job 'Replication agents checkup' (0xF2F0DE84FCFB1B46A009419F676E83A9) - Status: Failed - Invoked on: 2005-09-20 10:40:01 - Message: The job failed. Unable to determine if the owner (CORP\user) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'CORP\user'. [SQLSTATE 42000] (Error 8198)).
Kevin,
try changing the job owner to sa and then run the job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||but it's under pending mode.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:e2KvrjfvFHA.3500@.TK2MSFTNGP09.phx.gbl...
Kevin,
try changing the job owner to sa and then run the job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Kevin - I'm not too sure what's happening here - can't you change the job owner in SQL Server Agent, Jobs and then run it manually?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
|||now it's active.
Could you tell me what is difference between reinitialize subscription and synchronize? is that almost the same thing?
I'm assuming reinitialize subscription will refresh all the data,
and synchronize is just download the latest data.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:eXJhGhgvFHA.2076@.TK2MSFTNGP14.phx.gbl...
Kevin - I'm not too sure what's happening here - can't you change the job owner in SQL Server Agent, Jobs and then run it manually?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
|||Kevin,
reinitialize will require that a new snapshot be generated and sent down to the subscriber as a set of odbcBCP files. On the other hand, synchronize will run the distribution/merge agent and send down the latest changes. For merge the flow of data is in both directions and is just pub -> sub for normal transactional replication. In the case of snapshot replication, synchronization and reinitialization are quite similar, but there's a big difference for the other methods.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Since it's in active mode, and I'm using transaction replication,
I did a test. I change column defintion for one of the column on publisher, and when I go to subscriber, how come I don't see the change? I also wait about 12 hours, it is still not there. Is it because it's depending on schedule? how do I force the synchronization?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uMDS2PovFHA.2008@.TK2MSFTNGP10.phx.gbl...
Kevin,
reinitialize will require that a new snapshot be generated and sent down to the subscriber as a set of odbcBCP files. On the other hand, synchronize will run the distribution/merge agent and send down the latest changes. For merge the flow of data is in both directions and is just pub -> sub for normal transactional replication. In the case of snapshot replication, synchronization and reinitialization are quite similar, but there's a big difference for the other methods.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Kevin wrote on Wed, 21 Sep 2005 10:26:34 -0400:

> Since it's in active mode, and I'm using transaction replication,
> I did a test. I change column defintion for one of the column on
> publisher, and when I go to subscriber, how come I don't see the change?
> I also wait about 12 hours, it is still not there. Is it because it's
> depending on schedule? how do I force the synchronization?
Did you make the change using ALTER TABLE, or via the the
sp_repladdcolumn/sp_repldropcolumn procs or replication properties dialogs
in EM?. Check BOL for "Schema Changes on Publication Databases", according
to that ALTER TABLE changes to the schema are not replicated (I think I read
that SQL Server 2005 will be able to do this though).
Dan
|||YES. I changed it using alter table using following script. but I drop the article and then alter table, AND THEN I re-add article back in publication. SO even that method won't work?
altering the subscriptions
exec sp_dropsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
exec sp_droparticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
-- Change column definition
alter table tEmployees alter column Forename varchar(100) null
exec sp_addarticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.source_table = 'tEmployees'
exec sp_addsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message news:uYj2fPsvFHA.2132@.TK2MSFTNGP15.phx.gbl...
> Kevin wrote on Wed, 21 Sep 2005 10:26:34 -0400:
>
> Did you make the change using ALTER TABLE, or via the the
> sp_repladdcolumn/sp_repldropcolumn procs or replication properties dialogs
> in EM?. Check BOL for "Schema Changes on Publication Databases", according
> to that ALTER TABLE changes to the schema are not replicated (I think I read
> that SQL Server 2005 will be able to do this though).
> Dan
>
|||This is OK - if you're using transactional replication, you'll also need to run the snapshot then the distribution agents for it to go over. Also, Daniel's quite right that this type of tinkering is supported directly using the 'Replicate Schema Changes' option on the subscription options pane of SQL Server 2005 (by default is enabled).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)