Showing posts with label transactional. Show all posts
Showing posts with label transactional. Show all posts

Wednesday, March 21, 2012

MS SQL Server 2000 replication deployment

Hi
I want to implement transactional replication on 2 MS SQL Servers 2000
(SP3). Is there any good guide available that discusses crucial points in
this endeavour (e.g. possible topologies, what and how needs to be monitored,
potential issues to avoid, what to do in case of failures etc.)? I need a
document that focuses on moving the replication into production environment.
I'm especially interested in alternative means of monitoring the replication
rather than the built-in one.
Many thanks,
Oskar
You can check BOL, do a search on MSDN for transactional replication. You
might want to consider my book
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
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:3F9E5C48-79C8-4D76-87C8-B9C2ABC6C840@.microsoft.com...
> Hi
> I want to implement transactional replication on 2 MS SQL Servers 2000
> (SP3). Is there any good guide available that discusses crucial points in
> this endeavour (e.g. possible topologies, what and how needs to be
monitored,
> potential issues to avoid, what to do in case of failures etc.)? I need a
> document that focuses on moving the replication into production
environment.
> I'm especially interested in alternative means of monitoring the
replication
> rather than the built-in one.
> --
> Many thanks,
> Oskar
>
|||Yeah, but are you completely sure that these sources give answers to the
specific questions I have? So far I was unable to find answers to my
questions in BOL.
"Hilary Cotter" wrote:

> You can check BOL, do a search on MSDN for transactional replication. You
> might want to consider my book
> --
> 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
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:3F9E5C48-79C8-4D76-87C8-B9C2ABC6C840@.microsoft.com...
> monitored,
> environment.
> replication
>
>

Monday, March 19, 2012

MS SQL Replication Error -XParentProcessHandle

Recieving the following error when I try to fire off the snapshot agent for transactional replication. I'm new to 2005 replication. Any suggestions? Thanks,

2007-08-14 00:49:08.972 Status: 0, code: 20030, text: 'A syntax error occurred near parameter '-XParentProcessHandle'.'.
2007-08-14 00:49:08.972 A syntax error occurred near parameter '-XParentProcessHandle'.

Can you do select @.@.version and tell me the version of your publisher and distributor? And on what machine are you running the snapshot agent?

MS SQL Replication Error -XParentProcessHandle

Recieving the following error when I try to fire off the snapshot agent for transactional replication. I'm new to 2005 replication. Any suggestions? Thanks,

2007-08-14 00:49:08.972 Status: 0, code: 20030, text: 'A syntax error occurred near parameter '-XParentProcessHandle'.'.
2007-08-14 00:49:08.972 A syntax error occurred near parameter '-XParentProcessHandle'.

Can you do select @.@.version and tell me the version of your publisher and distributor? And on what machine are you running the snapshot agent?