May 25, 2009 at 3:16 am
Hi there,
I have a aprox 100 pull subscribers... Please, notice that theese are SQL 2000 (MSDE) klients... My problem is, that i cannot trust the replication monitor in management studio 2008... The "status" in the "Subscription watch list" is not nessesarily showing me the correct status.. It might say : Error.. But if you right click the subscriber, and choose details... It shows me that it is running... Or the status might be : Running, but if you right click and choose details, it might have an error...
Has anyone seen this before?? (notice, that we are not yet running SP1 on the sql 2008 server)..
The subscriptions where made from a script (from OSQL):
exec [Server\Serverinstance].Database.dbo.sp_addsubscription @publication = N'Database', @subscriber = N'%1', @destination_db = N'Database', @sync_type = N'Automatic', @subscription_type = N'pull', @update_mode = N'read only'
exec sp_addpullsubscription @publisher = N'Server\Serverinstance', @publication = N'Database', @publisher_db = N'Database', @independent_agent = N'True', @subscription_type = N'pull', @description = N'', @update_mode = N'read only', @immediate_sync = 1"
exec sp_addpullsubscription_agent @publisher = N'Server\Serverinstance', @publisher_db = N'Database', @publication = N'Database', @subscriber_security_mode = 1, @subscriber_login = N'', @subscriber_password = null, @distributor = N'Server\Serverinstance', @distributor_security_mode = 1, @distributor_login = N'', @distributor_password = null, @enabled_for_syncmgr = N'False', @frequency_type = 64, @frequency_interval = 0, @frequency_relative_interval = 0, @frequency_recurrence_factor = 0, @frequency_subday = 0, @frequency_subday_interval = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @active_start_date = 20090422, @active_end_date = 99991231, @alt_snapshot_folder = N'', @working_directory = N'', @use_ftp = N'False', @offloadagent = N'False', @offloadserver = N'', @publication_type = 0"
and the publication was made from this script:
exec sp_adddistributor @distributor = N'Server\Serverinstance', @password = N''
GO
exec sp_adddistributiondb @database = N'distribution', @data_folder = N'g:\datafiles', @log_folder = N'l:\logflies', @log_file_size = 2, @min_distretention = 0, @max_distretention = 72, @history_retention = 48, @security_mode = 1
GO
use [distribution]
if (not exists (select * from sysobjects where name = 'UIProperties' and type = 'U '))
create table UIProperties(id int)
if (exists (select * from ::fn_listextendedproperty('SnapshotFolder', 'user', 'dbo', 'table', 'UIProperties', null, null)))
EXEC sp_updateextendedproperty N'SnapshotFolder', N'\\Server\ReplData', 'user', dbo, 'table', 'UIProperties'
else
EXEC sp_addextendedproperty N'SnapshotFolder', N'\\Server\ReplData', 'user', dbo, 'table', 'UIProperties'
GO
exec sp_adddistpublisher @publisher = N'Server\Serverinstance', @distribution_db = N'distribution', @security_mode = 1, @working_directory = N'\\Server\ReplData', @trusted = N'false', @thirdparty_flag = 0, @publisher_type = N'MSSQLSERVER'
GO
use [Database]
exec sp_replicationdboption @dbname = N'Database', @optname = N'publish', @value = N'true'
GO
-- Adding the transactional publication
use [Database]
exec sp_addpublication @publication = N'Database', @description = N'Transactional publication of database ''Database'' from Publisher ''Server\serverinstace''.', @sync_method = N'concurrent', @retention = 0, @allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'true', @enabled_for_internet = N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @allow_subscription_copy = N'false', @add_to_active_directory = N'false', @repl_freq = N'continuous', @status = N'active', @independent_agent = N'true', @immediate_sync = N'true', @allow_sync_tran = N'false', @autogen_sync_procs = N'false', @allow_queued_tran = N'false', @allow_dts = N'false', @replicate_ddl = 1, @allow_initialize_from_backup = N'false', @enabled_for_p2p = N'false', @enabled_for_het_sub = N'false'
GO
exec sp_addpublication_snapshot @publication = N'Database', @frequency_type = 4, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 1, @frequency_subday_interval = 1, @active_start_time_of_day = 223000, @active_end_time_of_day = 235959, @active_start_date = 0, @active_end_date = 0, @job_login = null, @job_password = null, @publisher_security_mode = 1
May 28, 2009 at 7:45 am
It apparently had to do with that our SQL server 2008, is a SQL cluster.. When we failed over to the other node.. The error was not present...
October 6, 2009 at 7:47 am
Hi,
We are seeing very similar behaviour on a SQL cluster distribution server for SQL 2008. Can you advise whether the problem reoccurred when you failed back to the original node?
Cheers,
Russ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply