I reinstalled sql server 2000 on Windoes server 2003 three times due to diff
errors - 1st time replication recovery did not work; 2nd time typo in the
file name ; 3rd time typo in the server name. Then when I installed it the
4th time , the installation failed with system error [TCP/IP sockets] sq
l
server does not exist or access denied. Is this possible that the problem
is related to the port conflict in the machine?
Please advise !!!
Thanks.
Wen ChangRestart ur server delete all the installation files.
HTH
from
Doller
Wen Chang wrote:
> I reinstalled sql server 2000 on Windoes server 2003 three times due to di
ff
> errors - 1st time replication recovery did not work; 2nd time typo in the
> file name ; 3rd time typo in the server name. Then when I installed it th
e
> 4th time , the installation failed with system error [TCP/IP sockets]
sql
> server does not exist or access denied. Is this possible that the proble
m
> is related to the port conflict in the machine?
> Please advise !!!
> Thanks.
> Wen Chang
Showing posts with label replication. Show all posts
Showing posts with label replication. Show all posts
Tuesday, March 20, 2012
Monday, March 19, 2012
[SQL2000] Transactional replication and database filegroups
Hello everybory
Some general question about Transactionnal Replication features on SQL 2000
In case of using Trans. Repl. to duplicate a whole database to another SQL
2000 server, does the Transactionnal Replication preserve database's
filegroup (i.e. tables/indexes distributed accross different files on disk ) ?
No info found about it in the BOL or KB.
I have made some testings and even when the destination database is created
with multiple filegroups before transactionnal replicatiion activated, all
the tables fall in the PRIMARY filegroupn whatever their initial filegroup in
the source database.
Any option or hints to do this ?
Thank in advance
Jb,
you could script out the creation of filegroups and creation of objects onto
particular filegroups. On the publication properties, this script could be
made to run before the snapshot is applied. On the article properties,
naming conflicts section, you can select to leave the table intact if it
already exists. This bypasses the inbuilt snapshot schema generation.
HTH,
Paul Ibison
"Jb Vernejoux" <JbVernejoux@.discussions.microsoft.com> wrote in message
news:AB06D8F0-1CB8-4E44-AC66-FEBC5311CD8C@.microsoft.com...
> Hello everybory
> Some general question about Transactionnal Replication features on SQL
2000
> In case of using Trans. Repl. to duplicate a whole database to another SQL
> 2000 server, does the Transactionnal Replication preserve database's
> filegroup (i.e. tables/indexes distributed accross different files on
disk ) ?
> No info found about it in the BOL or KB.
> I have made some testings and even when the destination database is
created
> with multiple filegroups before transactionnal replicatiion activated, all
> the tables fall in the PRIMARY filegroupn whatever their initial filegroup
in
> the source database.
> Any option or hints to do this ?
> Thank in advance
|||use a pre snapshot command that adds the file groups. (Alter database test
add filegroup file_group).
and then add some files to this filegroup
ALTER DATABASE test
ADD FILE(NAME = 'test_FG', FILENAME = 'C:\temp\test_FG_Data.NDF', SIZE = 1,
FILEGROWTH = 10%) TO FILEGROUP [test]
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uuKyWTciEHA.2664@.TK2MSFTNGP11.phx.gbl...
> Jb,
> you could script out the creation of filegroups and creation of objects
onto[vbcol=seagreen]
> particular filegroups. On the publication properties, this script could be
> made to run before the snapshot is applied. On the article properties,
> naming conflicts section, you can select to leave the table intact if it
> already exists. This bypasses the inbuilt snapshot schema generation.
> HTH,
> Paul Ibison
> "Jb Vernejoux" <JbVernejoux@.discussions.microsoft.com> wrote in message
> news:AB06D8F0-1CB8-4E44-AC66-FEBC5311CD8C@.microsoft.com...
> 2000
SQL[vbcol=seagreen]
> disk ) ?
> created
all[vbcol=seagreen]
filegroup
> in
>
|||ok,
thanks all for your info
Jb VERNEJOUX
"Hilary Cotter" wrote:
> use a pre snapshot command that adds the file groups. (Alter database test
> add filegroup file_group).
> and then add some files to this filegroup
> ALTER DATABASE test
> ADD FILE(NAME = 'test_FG', FILENAME = 'C:\temp\test_FG_Data.NDF', SIZE = 1,
> FILEGROWTH = 10%) TO FILEGROUP [test]
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:uuKyWTciEHA.2664@.TK2MSFTNGP11.phx.gbl...
> onto
> SQL
> all
> filegroup
>
>
Some general question about Transactionnal Replication features on SQL 2000
In case of using Trans. Repl. to duplicate a whole database to another SQL
2000 server, does the Transactionnal Replication preserve database's
filegroup (i.e. tables/indexes distributed accross different files on disk ) ?
No info found about it in the BOL or KB.
I have made some testings and even when the destination database is created
with multiple filegroups before transactionnal replicatiion activated, all
the tables fall in the PRIMARY filegroupn whatever their initial filegroup in
the source database.
Any option or hints to do this ?
Thank in advance
Jb,
you could script out the creation of filegroups and creation of objects onto
particular filegroups. On the publication properties, this script could be
made to run before the snapshot is applied. On the article properties,
naming conflicts section, you can select to leave the table intact if it
already exists. This bypasses the inbuilt snapshot schema generation.
HTH,
Paul Ibison
"Jb Vernejoux" <JbVernejoux@.discussions.microsoft.com> wrote in message
news:AB06D8F0-1CB8-4E44-AC66-FEBC5311CD8C@.microsoft.com...
> Hello everybory
> Some general question about Transactionnal Replication features on SQL
2000
> In case of using Trans. Repl. to duplicate a whole database to another SQL
> 2000 server, does the Transactionnal Replication preserve database's
> filegroup (i.e. tables/indexes distributed accross different files on
disk ) ?
> No info found about it in the BOL or KB.
> I have made some testings and even when the destination database is
created
> with multiple filegroups before transactionnal replicatiion activated, all
> the tables fall in the PRIMARY filegroupn whatever their initial filegroup
in
> the source database.
> Any option or hints to do this ?
> Thank in advance
|||use a pre snapshot command that adds the file groups. (Alter database test
add filegroup file_group).
and then add some files to this filegroup
ALTER DATABASE test
ADD FILE(NAME = 'test_FG', FILENAME = 'C:\temp\test_FG_Data.NDF', SIZE = 1,
FILEGROWTH = 10%) TO FILEGROUP [test]
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uuKyWTciEHA.2664@.TK2MSFTNGP11.phx.gbl...
> Jb,
> you could script out the creation of filegroups and creation of objects
onto[vbcol=seagreen]
> particular filegroups. On the publication properties, this script could be
> made to run before the snapshot is applied. On the article properties,
> naming conflicts section, you can select to leave the table intact if it
> already exists. This bypasses the inbuilt snapshot schema generation.
> HTH,
> Paul Ibison
> "Jb Vernejoux" <JbVernejoux@.discussions.microsoft.com> wrote in message
> news:AB06D8F0-1CB8-4E44-AC66-FEBC5311CD8C@.microsoft.com...
> 2000
SQL[vbcol=seagreen]
> disk ) ?
> created
all[vbcol=seagreen]
filegroup
> in
>
|||ok,
thanks all for your info
Jb VERNEJOUX
"Hilary Cotter" wrote:
> use a pre snapshot command that adds the file groups. (Alter database test
> add filegroup file_group).
> and then add some files to this filegroup
> ALTER DATABASE test
> ADD FILE(NAME = 'test_FG', FILENAME = 'C:\temp\test_FG_Data.NDF', SIZE = 1,
> FILEGROWTH = 10%) TO FILEGROUP [test]
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:uuKyWTciEHA.2664@.TK2MSFTNGP11.phx.gbl...
> onto
> SQL
> all
> filegroup
>
>
[SQL Server 2000] How to programmatically read Merge Agent properties
Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...[vbcol=seagreen]
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...][vbcol=seagreen]
> Dan Guzman
> SQL Server MVP
>
Dan,
Thank you for your help!
Best regards,
Andrew
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...[vbcol=seagreen]
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...][vbcol=seagreen]
> Dan Guzman
> SQL Server MVP
>
Dan,
Thank you for your help!
Best regards,
Andrew
[SQL Server 2000] How to programmatically read Merge Agent properties
Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew
Sunday, March 11, 2012
[SQL 2005] Transactionnal replication via FTP
Here is the context, in short. I have 2 remote sites with SQL Server 2005.
Each server can't see the other one. I need to replicate data between them.
I use MSSQL Management Studio with SQL Server Developer Edition.
When creating a publication, I can say that I want the snapshot to be put on
a FTP in the publication option. no problem here. When I want to create a
subscribtion, I must give the publication to use, and there is the problem
because I can't see the remote server.
The only thing I need to do is to say the subscriber to take the snapshot on
the FTP, but I've not found how I can do this.
If someone can help me ^^
Thanks in advance.
P.S. : sorry for my bad english, I'm not very good with foreign language :p
Divid,
you'll need some sort of connectivity. This could be a VPN, HTTPS or just
TCP/IP (non-trusted). Somehow, the subscriber will need to contact the
publisher. If you want a purely FTP solution then you must use another
technology.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||VPN, in a wonderfull dream. Maybe one day ... or not :p
Merge replication can use HTTPS but the merge replication is not suitable in
my situation. Transactionnal replication can't use HTTPS as far as I know.
For the TCP/IP (non trusted), can you explain about this a little more. I
don't know what is it so maybe it could do the work.
Thanks again.
|||David,
this should help a bit:
http://www.replicationanswers.com/InternetArticle.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It doesn't really help. I've add the alias but I can't add a "virtual"
publisher (the alias), and then I can't subscribe it, in Management Studio.
Seems that I'm only able to work on local because local publishing/local
subscribtion are the only options in Management Studio.
|||David,
unfortunately I can't repro this at the moment as we only have one SQL
Server 2005 installation. As soon as another is added I'll give it a go, but
hopefully someone else will take up the thread before then.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Each server can't see the other one. I need to replicate data between them.
I use MSSQL Management Studio with SQL Server Developer Edition.
When creating a publication, I can say that I want the snapshot to be put on
a FTP in the publication option. no problem here. When I want to create a
subscribtion, I must give the publication to use, and there is the problem
because I can't see the remote server.
The only thing I need to do is to say the subscriber to take the snapshot on
the FTP, but I've not found how I can do this.
If someone can help me ^^
Thanks in advance.
P.S. : sorry for my bad english, I'm not very good with foreign language :p
Divid,
you'll need some sort of connectivity. This could be a VPN, HTTPS or just
TCP/IP (non-trusted). Somehow, the subscriber will need to contact the
publisher. If you want a purely FTP solution then you must use another
technology.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||VPN, in a wonderfull dream. Maybe one day ... or not :p
Merge replication can use HTTPS but the merge replication is not suitable in
my situation. Transactionnal replication can't use HTTPS as far as I know.
For the TCP/IP (non trusted), can you explain about this a little more. I
don't know what is it so maybe it could do the work.
Thanks again.
|||David,
this should help a bit:
http://www.replicationanswers.com/InternetArticle.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It doesn't really help. I've add the alias but I can't add a "virtual"
publisher (the alias), and then I can't subscribe it, in Management Studio.
Seems that I'm only able to work on local because local publishing/local
subscribtion are the only options in Management Studio.
|||David,
unfortunately I can't repro this at the moment as we only have one SQL
Server 2005 installation. As soon as another is added I'll give it a go, but
hopefully someone else will take up the thread before then.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
[REPL] server config for distributor server?
We are going to have two SQL 2000 Servers with a SQL 2005 distributor server that will handle 1 way transactional replication. What kind of server should I ask IT to spec out that would satisfy an installation such as this?
Our production DB is 30GB and we are replication about 60% of the data to another server.rack mountable
dual processor with hyperthreading
100 GB RAID (disk space is not that important, but might as well make it RAID)
16 GB Memory (from what I understand memory is the most important attribute)
any other suggestions...?
Our production DB is 30GB and we are replication about 60% of the data to another server.rack mountable
dual processor with hyperthreading
100 GB RAID (disk space is not that important, but might as well make it RAID)
16 GB Memory (from what I understand memory is the most important attribute)
any other suggestions...?
Thursday, March 8, 2012
[NEWBIE] Replication with MSDE 2000
Hi everybody,
can someone help me about replication ?
I want to install msde2000 on two machines (identical) and keep database
updated like mirroring, so my users can connect to mirrored data if primary
server crashed down.
The two machines are in my LAN with their own IP number
Is it Possible ?
Thanks in advance and sorry of my poor knowledge of MSDE features
Merlinweb
Hi Merlinweb,
Merge replication goes close to doing what you want if you keep it
synchronizing constantly. There is some latency with the updates but that's
ok in many scenarios. It works very well when the servers are on the same
LAN. You will need to consider though, how to make schema changes, etc. as
that introduces quite a few issues.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"il_Leva" <il_levaMACIAO@.hotmail.com> wrote in message
news:41c97bf0$1@.x-privat.org...
> Hi everybody,
> can someone help me about replication ?
> I want to install msde2000 on two machines (identical) and keep database
> updated like mirroring, so my users can connect to mirrored data if
> primary
> server crashed down.
> The two machines are in my LAN with their own IP number
> Is it Possible ?
> Thanks in advance and sorry of my poor knowledge of MSDE features
> Merlinweb
>
|||"Greg Low [MVP]" <greglow@.lowell.com.au> ha scritto nel messaggio
news:uDw9mGI6EHA.2584@.TK2MSFTNGP10.phx.gbl...
> Hi Merlinweb,
> Merge replication goes close to doing what you want if you keep it
> synchronizing constantly. There is some latency with the updates but
that's
> ok in many scenarios. It works very well when the servers are on the same
> LAN. You will need to consider though, how to make schema changes, etc. as
> that introduces quite a few issues.
Thank you very much !
Now I go and search something useful on the net about merge replication.
Cheers
Merlinweb
can someone help me about replication ?
I want to install msde2000 on two machines (identical) and keep database
updated like mirroring, so my users can connect to mirrored data if primary
server crashed down.
The two machines are in my LAN with their own IP number
Is it Possible ?
Thanks in advance and sorry of my poor knowledge of MSDE features
Merlinweb
Hi Merlinweb,
Merge replication goes close to doing what you want if you keep it
synchronizing constantly. There is some latency with the updates but that's
ok in many scenarios. It works very well when the servers are on the same
LAN. You will need to consider though, how to make schema changes, etc. as
that introduces quite a few issues.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"il_Leva" <il_levaMACIAO@.hotmail.com> wrote in message
news:41c97bf0$1@.x-privat.org...
> Hi everybody,
> can someone help me about replication ?
> I want to install msde2000 on two machines (identical) and keep database
> updated like mirroring, so my users can connect to mirrored data if
> primary
> server crashed down.
> The two machines are in my LAN with their own IP number
> Is it Possible ?
> Thanks in advance and sorry of my poor knowledge of MSDE features
> Merlinweb
>
|||"Greg Low [MVP]" <greglow@.lowell.com.au> ha scritto nel messaggio
news:uDw9mGI6EHA.2584@.TK2MSFTNGP10.phx.gbl...
> Hi Merlinweb,
> Merge replication goes close to doing what you want if you keep it
> synchronizing constantly. There is some latency with the updates but
that's
> ok in many scenarios. It works very well when the servers are on the same
> LAN. You will need to consider though, how to make schema changes, etc. as
> that introduces quite a few issues.
Thank you very much !
Now I go and search something useful on the net about merge replication.
Cheers
Merlinweb
Tuesday, March 6, 2012
[ms sql] How to add new table to merge replication ?
Hi,
How to add new table to merge replication ?
The handy thing with that procedure is that you can open it up and
look down to the line number, and read the comments, and maybe get an
idea of what the problem is, even if the error message is missing.
How to add new table to merge replication ?
When I do this in Enterpriise Manager i got an error:
Server: Msg 2758, Level 16, State 1, Procedure sp_addmergearticle,
Line 466
RAISERROR could not locate entry for error 20085 in sysmessages.
What is wrong ?
Thank for any help
LukOn Jul 12, 9:49 am, szaki <ljag...@.gmail.comwrote:
Quote:
Originally Posted by
Hi,
How to add new table to merge replication ?
>
When I do this in Enterpriise Manager i got an error:
Server: Msg 2758, Level 16, State 1, Procedure sp_addmergearticle,
Line 466
RAISERROR could not locate entry for error 20085 in sysmessages.
>
What is wrong ?
>
Thank for any help
>
Luk
The handy thing with that procedure is that you can open it up and
look down to the line number, and read the comments, and maybe get an
idea of what the problem is, even if the error message is missing.
Strangely, I can't find it raising 20085 at that line number - on SQL
2000 SP 4. But at that line, there is a check that all articles
contain a column marked with the rowguidcol property (and raising
error 20086). So, is that what's wrong with your table?
Damien
Friday, February 24, 2012
[Help] Snapshot replication & Full Text Indexing
Hi
I have setup snapshot replication in one of my sql database. The article
which i publish, has full text index enabled in the subscription db. So when
the initial snap shot is applied, i get a error message saying "cannot drop
index PK_<<table name>> because it enforces full text key. It really drives
me crazy.
Here are my questions
1. In the Artcile properties, page i specify, under the name conflict
section, leave the table un changed. Then why is it that sql server tries
to drop the table and recreate it.(i checked in the sch table, what ever
option i specify, it is adament, it wants to recreate the table).
2. Is there a way, to publish full text indexed tables, without the initial
snapshot failing ?
I am in "Developer in Distress" mode, can anyone help ?
Thank You
Shrinivas
1 & 2) this should work, could you post the schema of this problem table
here?
"shrini" <senor20@.hotmail.com> wrote in message
news:%23R4xv8vJEHA.620@.tk2msftngp13.phx.gbl...
> Hi
> I have setup snapshot replication in one of my sql database. The article
> which i publish, has full text index enabled in the subscription db. So
when
> the initial snap shot is applied, i get a error message saying "cannot
drop
> index PK_<<table name>> because it enforces full text key. It really
drives
> me crazy.
> Here are my questions
> 1. In the Artcile properties, page i specify, under the name conflict
> section, leave the table un changed. Then why is it that sql server tries
> to drop the table and recreate it.(i checked in the sch table, what ever
> option i specify, it is adament, it wants to recreate the table).
> 2. Is there a way, to publish full text indexed tables, without the
initial
> snapshot failing ?
> I am in "Developer in Distress" mode, can anyone help ?
> Thank You
> Shrinivas
>
|||Hi Hilary
I managed to work around this, by dropping the Full Text index before
applying the snap (by specifying sql in the snap shot tab of properties) and
recreating the index after the snap shot is created. I think this is the
possible way for doing this. Thanks for your reply.
Shrini
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:e3KduPFKEHA.2808@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> 1 & 2) this should work, could you post the schema of this problem table
> here?
> "shrini" <senor20@.hotmail.com> wrote in message
> news:%23R4xv8vJEHA.620@.tk2msftngp13.phx.gbl...
> when
> drop
> drives
tries
> initial
>
I have setup snapshot replication in one of my sql database. The article
which i publish, has full text index enabled in the subscription db. So when
the initial snap shot is applied, i get a error message saying "cannot drop
index PK_<<table name>> because it enforces full text key. It really drives
me crazy.
Here are my questions
1. In the Artcile properties, page i specify, under the name conflict
section, leave the table un changed. Then why is it that sql server tries
to drop the table and recreate it.(i checked in the sch table, what ever
option i specify, it is adament, it wants to recreate the table).
2. Is there a way, to publish full text indexed tables, without the initial
snapshot failing ?
I am in "Developer in Distress" mode, can anyone help ?
Thank You
Shrinivas
1 & 2) this should work, could you post the schema of this problem table
here?
"shrini" <senor20@.hotmail.com> wrote in message
news:%23R4xv8vJEHA.620@.tk2msftngp13.phx.gbl...
> Hi
> I have setup snapshot replication in one of my sql database. The article
> which i publish, has full text index enabled in the subscription db. So
when
> the initial snap shot is applied, i get a error message saying "cannot
drop
> index PK_<<table name>> because it enforces full text key. It really
drives
> me crazy.
> Here are my questions
> 1. In the Artcile properties, page i specify, under the name conflict
> section, leave the table un changed. Then why is it that sql server tries
> to drop the table and recreate it.(i checked in the sch table, what ever
> option i specify, it is adament, it wants to recreate the table).
> 2. Is there a way, to publish full text indexed tables, without the
initial
> snapshot failing ?
> I am in "Developer in Distress" mode, can anyone help ?
> Thank You
> Shrinivas
>
|||Hi Hilary
I managed to work around this, by dropping the Full Text index before
applying the snap (by specifying sql in the snap shot tab of properties) and
recreating the index after the snap shot is created. I think this is the
possible way for doing this. Thanks for your reply.
Shrini
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:e3KduPFKEHA.2808@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> 1 & 2) this should work, could you post the schema of this problem table
> here?
> "shrini" <senor20@.hotmail.com> wrote in message
> news:%23R4xv8vJEHA.620@.tk2msftngp13.phx.gbl...
> when
> drop
> drives
tries
> initial
>
Monday, February 13, 2012
[2005 beta 2] merge replication sql server to sql server mobile
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
You will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ################################################## ######################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ################################################## ######################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
You will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ################################################## ######################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ################################################## ######################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo
[2005 beta 2] merge replication sql server to sql server mobile
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
You will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ################################################## ######################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ################################################## ######################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo
|||Hi Diemo
I am facing the same problem...check the newsgroup and could not find any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
Originally posted by dieweb
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
You will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ################################################## ######################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ################################################## ######################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo
|||Hi Diemo
I am facing the same problem...check the newsgroup and could not find any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
Quote:
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo
[2005 beta 2] merge replication sql server to sql server mobile
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
########################################
################################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
########################################
################################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
DiemoYou will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ########################################
################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################
################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo|||Hi Diemo
I am facing the same problem...check the newsgroup and could not find
any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
dieweb wrote:
> *Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005
> supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database,
> but
> when i try to subscribe from my mobile database, i get the following
> error:
> ########################################
################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for
> this
> publication. If this snapshot is currently being generated, wait for
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################
################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to run
> the
> snapshot agent manually (snapshot.exe). I thought its the server,
> but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something
> like
> this to work and can give a short howto?
> Best regards
> Diemo *
DannyCheah
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1239516.html
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
########################################
################################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
########################################
################################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
DiemoYou will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ########################################
################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################
################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo|||Hi Diemo
I am facing the same problem...check the newsgroup and could not find
any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
dieweb wrote:
> *Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005
> supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database,
> but
> when i try to subscribe from my mobile database, i get the following
> error:
> ########################################
################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for
> this
> publication. If this snapshot is currently being generated, wait for
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################
################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to run
> the
> snapshot agent manually (snapshot.exe). I thought its the server,
> but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something
> like
> this to work and can give a short howto?
> Best regards
> Diemo *
DannyCheah
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1239516.html
[2005 beta 2] merge replication sql server to sql server mobile
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
########################################################################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
########################################################################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
DiemoYou will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ########################################################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo|||Hi Diemo
I am facing the same problem...check the newsgroup and could not fin
any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
dieweb wrote:
> *Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 200
> supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database
> but
> when i try to subscribe from my mobile database, i get the followin
> error:
> ########################################################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot fo
> this
> publication. If this snapshot is currently being generated, wait fo
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate i
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to ru
> the
> snapshot agent manually (snapshot.exe). I thought its the server
> but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get somethin
> like
> this to work and can give a short howto?
> Best regards
> Diemo
-
DannyChea
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message1239516.htm
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
########################################################################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
########################################################################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
DiemoYou will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ########################################################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo|||Hi Diemo
I am facing the same problem...check the newsgroup and could not fin
any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
dieweb wrote:
> *Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 200
> supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database
> but
> when i try to subscribe from my mobile database, i get the followin
> error:
> ########################################################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot fo
> this
> publication. If this snapshot is currently being generated, wait fo
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate i
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to ru
> the
> snapshot agent manually (snapshot.exe). I thought its the server
> but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get somethin
> like
> this to work and can give a short howto?
> Best regards
> Diemo
-
DannyChea
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message1239516.htm
Saturday, February 11, 2012
@working_directory
We are trying to create generic scripts to enable/configure replication at
various customer sites that purchase our product. As I have no way of
knowing which drive they will use for data and log file storage I would like
to set the @.working_directory parameter for sp_adddistpublisher to null.
Will this cause the default UNC (\\<servername>\<drive letter>$\Program
Files\Microsoft SQL Server\MSSQL\ReplData) to be used?
Thanks,
Mark
Hi Mark, the SQL2005 version of sp_adddistpublisher will provide the
behavior that you want but unfortunately the change has not been (and will
unlikey be) backported to any versions of SQL2000. In SQL2005, we use the
following xp_instance_regread call to find out the root data folder path of
SQL Server so you may be able to do something similar:
EXECUTE @.retcode = master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Setup',
'SQLDataRoot',
@.param = @.working_directory OUTPUT,
@.no_output = 'no_output'
Hope that helps.
-Raymond
"mrprice" <mrprice@.discussions.microsoft.com> wrote in message
news:22060AF0-414E-4BA0-8C98-FA643FCFB83C@.microsoft.com...
> We are trying to create generic scripts to enable/configure replication at
> various customer sites that purchase our product. As I have no way of
> knowing which drive they will use for data and log file storage I would
> like
> to set the @.working_directory parameter for sp_adddistpublisher to null.
> Will this cause the default UNC (\\<servername>\<drive letter>$\Program
> Files\Microsoft SQL Server\MSSQL\ReplData) to be used?
> Thanks,
> Mark
>
|||Raymond,
As it needs to be a UNC, I'm doing this? Look reasonable?
DECLARE @.retcode INT
DECLARE @.pubworkingdir SYSNAME
EXECUTE @.retcode = master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Replication',
'WorkingDirectory',
@.pubworkingdir OUTPUT,
'no_output'
SET @.pubworkingdir = '\\' + @.@.SERVERNAME + '\' + REPLACE(@.pubworkingdir,
':', '$')
Thanks,
Mark
|||You may want to use serverproperty('MachineName') instead of @.@.servername to
get the "real" server name. Other than that, your code snippet looks fine to
me (you should, of course, test it extensively in your environment...)
"mrprice" <mrprice@.discussions.microsoft.com> wrote in message
news:060F1CA5-EDCE-4EC8-824A-CD5F12F05D21@.microsoft.com...
> Raymond,
> As it needs to be a UNC, I'm doing this? Look reasonable?
> DECLARE @.retcode INT
> DECLARE @.pubworkingdir SYSNAME
> EXECUTE @.retcode = master.dbo.xp_instance_regread
> 'HKEY_LOCAL_MACHINE',
> 'SOFTWARE\Microsoft\MSSQLServer\Replication',
> 'WorkingDirectory',
> @.pubworkingdir OUTPUT,
> 'no_output'
> SET @.pubworkingdir = '\\' + @.@.SERVERNAME + '\' + REPLACE(@.pubworkingdir,
> ':', '$')
> Thanks,
> Mark
various customer sites that purchase our product. As I have no way of
knowing which drive they will use for data and log file storage I would like
to set the @.working_directory parameter for sp_adddistpublisher to null.
Will this cause the default UNC (\\<servername>\<drive letter>$\Program
Files\Microsoft SQL Server\MSSQL\ReplData) to be used?
Thanks,
Mark
Hi Mark, the SQL2005 version of sp_adddistpublisher will provide the
behavior that you want but unfortunately the change has not been (and will
unlikey be) backported to any versions of SQL2000. In SQL2005, we use the
following xp_instance_regread call to find out the root data folder path of
SQL Server so you may be able to do something similar:
EXECUTE @.retcode = master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Setup',
'SQLDataRoot',
@.param = @.working_directory OUTPUT,
@.no_output = 'no_output'
Hope that helps.
-Raymond
"mrprice" <mrprice@.discussions.microsoft.com> wrote in message
news:22060AF0-414E-4BA0-8C98-FA643FCFB83C@.microsoft.com...
> We are trying to create generic scripts to enable/configure replication at
> various customer sites that purchase our product. As I have no way of
> knowing which drive they will use for data and log file storage I would
> like
> to set the @.working_directory parameter for sp_adddistpublisher to null.
> Will this cause the default UNC (\\<servername>\<drive letter>$\Program
> Files\Microsoft SQL Server\MSSQL\ReplData) to be used?
> Thanks,
> Mark
>
|||Raymond,
As it needs to be a UNC, I'm doing this? Look reasonable?
DECLARE @.retcode INT
DECLARE @.pubworkingdir SYSNAME
EXECUTE @.retcode = master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Replication',
'WorkingDirectory',
@.pubworkingdir OUTPUT,
'no_output'
SET @.pubworkingdir = '\\' + @.@.SERVERNAME + '\' + REPLACE(@.pubworkingdir,
':', '$')
Thanks,
Mark
|||You may want to use serverproperty('MachineName') instead of @.@.servername to
get the "real" server name. Other than that, your code snippet looks fine to
me (you should, of course, test it extensively in your environment...)
"mrprice" <mrprice@.discussions.microsoft.com> wrote in message
news:060F1CA5-EDCE-4EC8-824A-CD5F12F05D21@.microsoft.com...
> Raymond,
> As it needs to be a UNC, I'm doing this? Look reasonable?
> DECLARE @.retcode INT
> DECLARE @.pubworkingdir SYSNAME
> EXECUTE @.retcode = master.dbo.xp_instance_regread
> 'HKEY_LOCAL_MACHINE',
> 'SOFTWARE\Microsoft\MSSQLServer\Replication',
> 'WorkingDirectory',
> @.pubworkingdir OUTPUT,
> 'no_output'
> SET @.pubworkingdir = '\\' + @.@.SERVERNAME + '\' + REPLACE(@.pubworkingdir,
> ':', '$')
> Thanks,
> Mark
@update_mode for Bidirectional Transactional Replication
Hi
I'm in the process of working out how we are going to set up
replication for a client. Quite a daunting task.
I'm think we are going to use Bidirectional Transactional Replication,
as described here:
http://support.microsoft.com/default.aspx?scid=820675
If you look at the sample you will see that they use @.update_mode =
N'sync tran' when creating the subscription. Is this necessary? I set
it up using @.update_mode = N'read only', which seemed to work fine, but
I am worried that I might be missing something.
Any comments welcome...
Thanks
Gary
that's a doc bug - it should read readonly.
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
"Gary van der Merwe" <garyvdm@.gmail.com> wrote in message
news:1130327855.663530.282590@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm in the process of working out how we are going to set up
> replication for a client. Quite a daunting task.
> I'm think we are going to use Bidirectional Transactional Replication,
> as described here:
> http://support.microsoft.com/default.aspx?scid=820675
> If you look at the sample you will see that they use @.update_mode =
> N'sync tran' when creating the subscription. Is this necessary? I set
> it up using @.update_mode = N'read only', which seemed to work fine, but
> I am worried that I might be missing something.
> Any comments welcome...
> Thanks
> Gary
>
I'm in the process of working out how we are going to set up
replication for a client. Quite a daunting task.
I'm think we are going to use Bidirectional Transactional Replication,
as described here:
http://support.microsoft.com/default.aspx?scid=820675
If you look at the sample you will see that they use @.update_mode =
N'sync tran' when creating the subscription. Is this necessary? I set
it up using @.update_mode = N'read only', which seemed to work fine, but
I am worried that I might be missing something.
Any comments welcome...
Thanks
Gary
that's a doc bug - it should read readonly.
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
"Gary van der Merwe" <garyvdm@.gmail.com> wrote in message
news:1130327855.663530.282590@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm in the process of working out how we are going to set up
> replication for a client. Quite a daunting task.
> I'm think we are going to use Bidirectional Transactional Replication,
> as described here:
> http://support.microsoft.com/default.aspx?scid=820675
> If you look at the sample you will see that they use @.update_mode =
> N'sync tran' when creating the subscription. Is this necessary? I set
> it up using @.update_mode = N'read only', which seemed to work fine, but
> I am worried that I might be missing something.
> Any comments welcome...
> Thanks
> Gary
>
@bitmap was not supplied to upd procedure in transactional
Initially when I had setup my transactional replication I had created it with
out taking a snapshot and by synching the databases.
Now I am trying to add new table to one of my existing publication in
production by creating scripts for ins, upd and del in test server and
deploying it to subscriber but it throws an error saying
"sp_MSupd_tablenameexpects parameter '@.bitmap', which was not supplied"
Inserts just work fine.
This is what i used to add-
exec sp_addarticle @.publication = 'Repl_Source'
, @.article = TableName
, @.source_table = TableName
, @.sync_object = null
exec sp_addsubscription @.publication = 'Repl_Source'
, @.article = TableName
, @.subscriber = SERVERNAME
, @.destination_db = 'Repl_Destination'
how many columns are in your table?
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
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:AF5F5FE4-E43C-48C6-8FF9-9739C7C3DE62@.microsoft.com...
> Initially when I had setup my transactional replication I had created it
> with
> out taking a snapshot and by synching the databases.
> Now I am trying to add new table to one of my existing publication in
> production by creating scripts for ins, upd and del in test server and
> deploying it to subscriber but it throws an error saying
> "sp_MSupd_tablenameexpects parameter '@.bitmap', which was not supplied"
> Inserts just work fine.
> This is what i used to add-
> exec sp_addarticle @.publication = 'Repl_Source'
> , @.article = TableName
> , @.source_table = TableName
> , @.sync_object = null
> exec sp_addsubscription @.publication = 'Repl_Source'
> , @.article = TableName
> , @.subscriber = SERVERNAME
> , @.destination_db = 'Repl_Destination'
>
>
|||18 columns.
If I rememebr correctly I have tested same before a 6 months agao on
different table and i rememeber it working. Not sure what changed.
"Hilary Cotter" wrote:
> how many columns are in your table?
> --
> 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
> "SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
> message news:AF5F5FE4-E43C-48C6-8FF9-9739C7C3DE62@.microsoft.com...
>
>
|||Hi Hilary,
I think this is what thats happenening
- As I have scripted ins, upd and del scripts in dev environment by
generating them by running snapshot in transactional replication, those are
scripted with @.bitmap varaiable.
- Looks like the code I have used to add subscription
exec sp_addsubscription @.publication = 'Repl_Source'
, @.article = TableName
, @.subscriber = SERVERNAME
, @.destination_db = 'Repl_Destination'
is trying for ins, upd and del procs with no @.bitmap.
Instead of above code I have used
exec sp_addsubscription
@.publication = Repl_Source,
@.article = TableName,
@.subscriber = SERVERNAME,
@.destination_db = 'Repl_Destination',
@.sync_type = N'automatic',
@.subscription_type = N'pull',
@.update_mode = N'read only'
then when i made data changes it asked for snapshot to be execute dfirst and
it created sp's at destination with out bitmap
As all my other sp's were created during initial setup with bitmap i would
like them to be in sync . rather than some with bitmap variable and some with
out..
Any advise....
"SQL Replication Guy" wrote:
[vbcol=seagreen]
> 18 columns.
>
> If I rememebr correctly I have tested same before a 6 months agao on
> different table and i rememeber it working. Not sure what changed.
> "Hilary Cotter" wrote:
|||return to your publisher and in qa change to the publication database, then
recreate your replication procs by issuing a sp_scriptpublicationcustomprocs
'publicationName'
then copy what you find in the results pane, go to the subscriber, change to
the subscription database, and paste these results into qa and run them.
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
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:C261558E-58A6-4810-A5E1-AB24439B9A9E@.microsoft.com...[vbcol=seagreen]
> Hi Hilary,
> I think this is what thats happenening
> - As I have scripted ins, upd and del scripts in dev environment by
> generating them by running snapshot in transactional replication, those
> are
> scripted with @.bitmap varaiable.
> - Looks like the code I have used to add subscription
> exec sp_addsubscription @.publication = 'Repl_Source'
> , @.article = TableName
> , @.subscriber = SERVERNAME
> , @.destination_db = 'Repl_Destination'
> is trying for ins, upd and del procs with no @.bitmap.
>
> Instead of above code I have used
> exec sp_addsubscription
> @.publication = Repl_Source,
> @.article = TableName,
> @.subscriber = SERVERNAME,
> @.destination_db = 'Repl_Destination',
> @.sync_type = N'automatic',
> @.subscription_type = N'pull',
> @.update_mode = N'read only'
> then when i made data changes it asked for snapshot to be execute dfirst
> and
> it created sp's at destination with out bitmap
>
> As all my other sp's were created during initial setup with bitmap i would
> like them to be in sync . rather than some with bitmap variable and some
> with
> out..
> Any advise....
>
> "SQL Replication Guy" wrote:
|||Hi Hilary,
I was trying several options soory could get to try your option but this
worked--
sp_addarticle
@.publication = 'Repl_Source',
@.article = 'TableName',
@.source_object = 'TableName',
@.destination_table = 'TableName',
@.ins_cmd = 'call sp_MSins_TableName,
@.del_cmd = 'call sp_MSdel_TableName',
@.upd_cmd = 'mcall sp_MSupd_TableName', -- MCALL CREATED bitmap in UPD sp
@.type = 'logbased',
@.pre_creation_cmd = 'drop',
@.status = 16,
@.source_owner = 'dbo',
@.vertical_partition = 'false',
@.filter = Null,
@.auto_identity_range = 'false'
and then
exec sp_addsubscription @.publication = 'Repl_Source'
, @.article = TableName
, @.subscriber = SERVERNAME
, @.destination_db = 'Repl_Destination'
"SQL Replication Guy" wrote:
> Initially when I had setup my transactional replication I had created it with
> out taking a snapshot and by synching the databases.
> Now I am trying to add new table to one of my existing publication in
> production by creating scripts for ins, upd and del in test server and
> deploying it to subscriber but it throws an error saying
> "sp_MSupd_tablenameexpects parameter '@.bitmap', which was not supplied"
> Inserts just work fine.
> This is what i used to add-
> exec sp_addarticle @.publication = 'Repl_Source'
> , @.article = TableName
> , @.source_table = TableName
> , @.sync_object = null
> exec sp_addsubscription @.publication = 'Repl_Source'
> , @.article = TableName
> , @.subscriber = SERVERNAME
> , @.destination_db = 'Repl_Destination'
>
>
out taking a snapshot and by synching the databases.
Now I am trying to add new table to one of my existing publication in
production by creating scripts for ins, upd and del in test server and
deploying it to subscriber but it throws an error saying
"sp_MSupd_tablenameexpects parameter '@.bitmap', which was not supplied"
Inserts just work fine.
This is what i used to add-
exec sp_addarticle @.publication = 'Repl_Source'
, @.article = TableName
, @.source_table = TableName
, @.sync_object = null
exec sp_addsubscription @.publication = 'Repl_Source'
, @.article = TableName
, @.subscriber = SERVERNAME
, @.destination_db = 'Repl_Destination'
how many columns are in your table?
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
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:AF5F5FE4-E43C-48C6-8FF9-9739C7C3DE62@.microsoft.com...
> Initially when I had setup my transactional replication I had created it
> with
> out taking a snapshot and by synching the databases.
> Now I am trying to add new table to one of my existing publication in
> production by creating scripts for ins, upd and del in test server and
> deploying it to subscriber but it throws an error saying
> "sp_MSupd_tablenameexpects parameter '@.bitmap', which was not supplied"
> Inserts just work fine.
> This is what i used to add-
> exec sp_addarticle @.publication = 'Repl_Source'
> , @.article = TableName
> , @.source_table = TableName
> , @.sync_object = null
> exec sp_addsubscription @.publication = 'Repl_Source'
> , @.article = TableName
> , @.subscriber = SERVERNAME
> , @.destination_db = 'Repl_Destination'
>
>
|||18 columns.
If I rememebr correctly I have tested same before a 6 months agao on
different table and i rememeber it working. Not sure what changed.
"Hilary Cotter" wrote:
> how many columns are in your table?
> --
> 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
> "SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
> message news:AF5F5FE4-E43C-48C6-8FF9-9739C7C3DE62@.microsoft.com...
>
>
|||Hi Hilary,
I think this is what thats happenening
- As I have scripted ins, upd and del scripts in dev environment by
generating them by running snapshot in transactional replication, those are
scripted with @.bitmap varaiable.
- Looks like the code I have used to add subscription
exec sp_addsubscription @.publication = 'Repl_Source'
, @.article = TableName
, @.subscriber = SERVERNAME
, @.destination_db = 'Repl_Destination'
is trying for ins, upd and del procs with no @.bitmap.
Instead of above code I have used
exec sp_addsubscription
@.publication = Repl_Source,
@.article = TableName,
@.subscriber = SERVERNAME,
@.destination_db = 'Repl_Destination',
@.sync_type = N'automatic',
@.subscription_type = N'pull',
@.update_mode = N'read only'
then when i made data changes it asked for snapshot to be execute dfirst and
it created sp's at destination with out bitmap
As all my other sp's were created during initial setup with bitmap i would
like them to be in sync . rather than some with bitmap variable and some with
out..
Any advise....
"SQL Replication Guy" wrote:
[vbcol=seagreen]
> 18 columns.
>
> If I rememebr correctly I have tested same before a 6 months agao on
> different table and i rememeber it working. Not sure what changed.
> "Hilary Cotter" wrote:
|||return to your publisher and in qa change to the publication database, then
recreate your replication procs by issuing a sp_scriptpublicationcustomprocs
'publicationName'
then copy what you find in the results pane, go to the subscriber, change to
the subscription database, and paste these results into qa and run them.
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
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:C261558E-58A6-4810-A5E1-AB24439B9A9E@.microsoft.com...[vbcol=seagreen]
> Hi Hilary,
> I think this is what thats happenening
> - As I have scripted ins, upd and del scripts in dev environment by
> generating them by running snapshot in transactional replication, those
> are
> scripted with @.bitmap varaiable.
> - Looks like the code I have used to add subscription
> exec sp_addsubscription @.publication = 'Repl_Source'
> , @.article = TableName
> , @.subscriber = SERVERNAME
> , @.destination_db = 'Repl_Destination'
> is trying for ins, upd and del procs with no @.bitmap.
>
> Instead of above code I have used
> exec sp_addsubscription
> @.publication = Repl_Source,
> @.article = TableName,
> @.subscriber = SERVERNAME,
> @.destination_db = 'Repl_Destination',
> @.sync_type = N'automatic',
> @.subscription_type = N'pull',
> @.update_mode = N'read only'
> then when i made data changes it asked for snapshot to be execute dfirst
> and
> it created sp's at destination with out bitmap
>
> As all my other sp's were created during initial setup with bitmap i would
> like them to be in sync . rather than some with bitmap variable and some
> with
> out..
> Any advise....
>
> "SQL Replication Guy" wrote:
|||Hi Hilary,
I was trying several options soory could get to try your option but this
worked--
sp_addarticle
@.publication = 'Repl_Source',
@.article = 'TableName',
@.source_object = 'TableName',
@.destination_table = 'TableName',
@.ins_cmd = 'call sp_MSins_TableName,
@.del_cmd = 'call sp_MSdel_TableName',
@.upd_cmd = 'mcall sp_MSupd_TableName', -- MCALL CREATED bitmap in UPD sp
@.type = 'logbased',
@.pre_creation_cmd = 'drop',
@.status = 16,
@.source_owner = 'dbo',
@.vertical_partition = 'false',
@.filter = Null,
@.auto_identity_range = 'false'
and then
exec sp_addsubscription @.publication = 'Repl_Source'
, @.article = TableName
, @.subscriber = SERVERNAME
, @.destination_db = 'Repl_Destination'
"SQL Replication Guy" wrote:
> Initially when I had setup my transactional replication I had created it with
> out taking a snapshot and by synching the databases.
> Now I am trying to add new table to one of my existing publication in
> production by creating scripts for ins, upd and del in test server and
> deploying it to subscriber but it throws an error saying
> "sp_MSupd_tablenameexpects parameter '@.bitmap', which was not supplied"
> Inserts just work fine.
> This is what i used to add-
> exec sp_addarticle @.publication = 'Repl_Source'
> , @.article = TableName
> , @.source_table = TableName
> , @.sync_object = null
> exec sp_addsubscription @.publication = 'Repl_Source'
> , @.article = TableName
> , @.subscriber = SERVERNAME
> , @.destination_db = 'Repl_Destination'
>
>
Thursday, February 9, 2012
@@servername returns NULL value
I have a SQL 2005 clustered server which is returning a Null value for @.@.servername. I find the server entry in sysservers. I have replication configured on this so i am not able to do a Sp_dropserver & sp_addserver as this acts as a publisher. The configured merge repication stopped working because of this issue and I am not able to delete replication as the the delete option uses @.@.servername which returns a null value. So I am struck in a loop.
Any advice is appreciated.
thanks
For a machine to be considered local, srvid = 0 in sysservers. Can you check on this?
Can a simple reboot of the nodes fix the problem? Otherwise how did you get into this state, considering you have replication set up properly already?
|||Hi,
Have you rename the virtual server name or the participating node name?
Peng
@@servername returning NULL
I have a SQL 2005 clustered server which is returning a Null value for @.@.servername. I find the server entry in sysservers. I have replication configured on this so i am not able to do a Sp_dropserver & sp_addserver as this acts as a publisher. The configured merge repication stopped working because of this issue and I am not able to delete replication as the the delete option uses @.@.servername which returns a null value. So I am struck in a loop.
Any advice is appreciated.
thanks
@.@.Servername of null can happen if there is no entry in sys.servers for server_id 0. check sys.servers with this:
select * from sys.servers where server_id=0
If this returns 0 rows you can add the local server with
sp_addserver '<servername>', local
you will need to restart the server for this to take effect.
Subscribe to:
Posts (Atom)