Hi,
Apologies if the answer to this is obvious, I'm not a SQL expert!
We've got a W2k3 cluster running SQL 2000 Enterprise edition.
I'm investigating the possibility of replicating this back to a standalone,
SQL 2000 Standard server.
Is this possible, or is not recommended to mix clustering arrangements or
SQL versions when replicating?
Pocket
This arrangement is fine. There are some restrictions as to which edition
can be the publisher in transactional replication, but this applies to MSDE
and Personal Edition. For Enterprise and Standard there are no issues.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
Thank you: that's answered my question perfectly.
"Paul Ibison" wrote:
> This arrangement is fine. There are some restrictions as to which edition
> can be the publisher in transactional replication, but this applies to MSDE
> and Personal Edition. For Enterprise and Standard there are no issues.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment