The schema script xxxxxxx.sch could not be propagated to subscriber.

[Database Administrator]

Hi

I'm trying Merge replication with pull subscriber and dynamic filter.
I put -hostname like this: -hostname @@servername at step job of Merge agent
at subscriber, so when start first snapshot, show this message:

The schema script '\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\un c\
D001ADP01$BDP01_Ddes950_Pub_T950GARA\2006121512091 8\T950GARA_1.sch' could not
be propagated to the subscriber. The step failed.

I see many articles about fix, wrong script, reindex at table, rewrite
transact script, but anyone just correct the problem.

Sds!

Krisnamourt.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ation/200612/1

[Database Administrator]

from your subscriber can you connect to this path?

\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\unc \D001ADP01BDP01_Ddes950_Pub_T950GARA\2006121512091 8\
If so, check to see if the account the SQL Server agent is running on can
access this share. It will need to be able to list files and folders, so if
it can't access it, you will have to grant it rights to.



--
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



"Krisnamourt" wrote in message news:6acd690b3a095@uwe...
> Hi
>
> I'm trying Merge replication with pull subscriber and dynamic filter.
> I put -hostname like this: -hostname @@servername at step job of Merge
> agent
> at subscriber, so when start first snapshot, show this message:
>
> The schema script '\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\un c\
> D001ADP01$BDP01_Ddes950_Pub_T950GARA\2006121512091 8\T950GARA_1.sch' could
> not
> be propagated to the subscriber. The step failed.
>
> I see many articles about fix, wrong script, reindex at table, rewrite
> transact script, but anyone just correct the problem.
>
> Sds!
>
> Krisnamourt.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums...ation/200612/1
>

[Database Administrator]

Yes. The problem wasn't anything about file access. I have read many Paul
articles at replicationanswers and put my energy at subscriber. So , I
rewrite all scripts and make some changes....CHEES, work fine. These are pull
subscriber scripts:
use ddes400_rep
go
EXEC sp_dropmergepullsubscription @publication = N'Pub_T950GARA'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @reserved = 0
GO
exec sp_addmergepullsubscription @publication = N'Pub_T950GARA'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @subscriber_type = 'LOCAL'
, @subscription_priority = 0.000000
, @sync_type = 'AUTOMATIC'
, @description = 'AGENT PULL MERGE'
go
declare @cmd varchar(255),@Ag char(3)
set @Ag ='190'
set @cmd = '-hostname '+ @Ag+ ' -output d:\sqldevices\LogReplicacaoMerge.log -
outputverboselevel 3'
EXEC sp_addmergepullsubscription_agent
@name = 'AGENTE PULL MERGE'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @publication = 'PUB_T950GARA'
, @publisher_security_mode = 1
, @subscriber = 'AG031_GER01'
, @subscriber_db = 'DDES400_REP'
, @distributor = 'D001ADP01\BDP01'
, @subscriber_security_mode = 1,
@distributor_security_mode = 1,
@frequency_type = 64,
@frequency_interval = 1,
@frequency_relative_interval = 1,
@frequency_recurrence_factor = 0,
@frequency_subday = 4,
@frequency_subday_interval = 5,
@active_start_date = 0,
@active_end_date = 0,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959
,@optional_command_line = @cmd


THANKS EVERYBODY!!!!!!!!

Hilary Cotter wrote:
>from your subscriber can you connect to this path?
>
>\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\unc \D001ADP01BDP01_Ddes950_Pub_T950GARA\2006121512091 8\
>If so, check to see if the account the SQL Server agent is running on can
>access this share. It will need to be able to list files and folders, so if
>it can't access it, you will have to grant it rights to.
>
>> Hi
>>
>[quoted text clipped - 14 lines]
>>
>> Krisnamourt.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ation/200612/1

[Database Administrator]

Yes. The problem wasn't anything about file access. I have read many Paul
articles at replicationanswers and put my energy at subscriber. So , I
rewrite all scripts and make some changes....CHEES, work fine. These are pull
subscriber scripts:
use ddes400_rep
go
EXEC sp_dropmergepullsubscription @publication = N'Pub_T950GARA'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @reserved = 0
GO
exec sp_addmergepullsubscription @publication = N'Pub_T950GARA'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @subscriber_type = 'LOCAL'
, @subscription_priority = 0.000000
, @sync_type = 'AUTOMATIC'
, @description = 'AGENT PULL MERGE'
go
declare @cmd varchar(255),@Ag char(3)
set @Ag ='190'
set @cmd = '-hostname '+ @Ag+ ' -output d:\sqldevices\LogReplicacaoMerge.log -
outputverboselevel 3'
EXEC sp_addmergepullsubscription_agent
@name = 'AGENTE PULL MERGE'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @publication = 'PUB_T950GARA'
, @publisher_security_mode = 1
, @subscriber = 'AG031_GER01'
, @subscriber_db = 'DDES400_REP'
, @distributor = 'D001ADP01\BDP01'
, @subscriber_security_mode = 1,
@distributor_security_mode = 1,
@frequency_type = 64,
@frequency_interval = 1,
@frequency_relative_interval = 1,
@frequency_recurrence_factor = 0,
@frequency_subday = 4,
@frequency_subday_interval = 5,
@active_start_date = 0,
@active_end_date = 0,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959
,@optional_command_line = @cmd


THANKS EVERYBODY!!!!!!!!

Hilary Cotter wrote:
>from your subscriber can you connect to this path?
>
>\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\unc \D001ADP01BDP01_Ddes950_Pub_T950GARA\2006121512091 8\
>If so, check to see if the account the SQL Server agent is running on can
>access this share. It will need to be able to list files and folders, so if
>it can't access it, you will have to grant it rights to.
>
>> Hi
>>
>[quoted text clipped - 14 lines]
>>
>> Krisnamourt.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ation/200612/1

[Database Administrator]

Yes. The problem wasn't anything about file access. I have read many Paul
articles at replicationanswers and put my energy at subscriber. So , I
rewrite all scripts and make some changes....CHEES, work fine. These are pull
subscriber scripts:
use ddes400_rep
go
EXEC sp_dropmergepullsubscription @publication = N'Pub_T950GARA'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @reserved = 0
GO
exec sp_addmergepullsubscription @publication = N'Pub_T950GARA'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @subscriber_type = 'LOCAL'
, @subscription_priority = 0.000000
, @sync_type = 'AUTOMATIC'
, @description = 'AGENT PULL MERGE'
go
declare @cmd varchar(255),@Ag char(3)
set @Ag ='190'
set @cmd = '-hostname '+ @Ag+ ' -output d:\sqldevices\LogReplicacaoMerge.log -
outputverboselevel 3'
EXEC sp_addmergepullsubscription_agent
@name = 'AGENTE PULL MERGE'
, @publisher = 'D001ADP01\BDP01'
, @publisher_db = 'DDES950'
, @publication = 'PUB_T950GARA'
, @publisher_security_mode = 1
, @subscriber = 'AG031_GER01'
, @subscriber_db = 'DDES400_REP'
, @distributor = 'D001ADP01\BDP01'
, @subscriber_security_mode = 1,
@distributor_security_mode = 1,
@frequency_type = 64,
@frequency_interval = 1,
@frequency_relative_interval = 1,
@frequency_recurrence_factor = 0,
@frequency_subday = 4,
@frequency_subday_interval = 5,
@active_start_date = 0,
@active_end_date = 0,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959
,@optional_command_line = @cmd


THANKS EVERYBODY!!!!!!!!

Hilary Cotter wrote:
>from your subscriber can you connect to this path?
>
>\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\unc \D001ADP01BDP01_Ddes950_Pub_T950GARA\2006121512091 8\
>If so, check to see if the account the SQL Server agent is running on can
>access this share. It will need to be able to list files and folders, so if
>it can't access it, you will have to grant it rights to.
>
>> Hi
>>
>[quoted text clipped - 14 lines]
>>
>> Krisnamourt.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...ation/200612/1

[Madhukar1976]

Hello Dear

Correct the "snapshot location" property of subscriber and it will solve your problem

Madhukar

[bizexpert]

I am creating a jobsite in Java(JSP, Servlets, Struts, EJB etc). I am having a huge database. I want to inquire which database will be suitable for me from cost point of view and from efficiency/security point of view. I know Oracle is the best database. I am told that MySQL is free but is it suitable for huge databases. Is MySQL really free? Well, I am totally confused. If anybody of you worked on similar things I will really appreciate you suggestion. Thank you.