Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 replication question

Author  Topic 

joanne
Starting Member

46 Posts

Posted - 2005-05-27 : 08:08:34
Hello,
I want to know if I can do a replication between two databases on the same server(same instance) and between two databases on two different servers with STANDARD edition.
What's more, I want to know where I can find information about replication.
Thanks a lot

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2005-05-27 : 09:19:21
Hi,

You cant use replication between 2 databases on the same server.
Standard edition will not support many of the advanced features. This edition is only for small workgroups. Relational database ngine features not supported on this edition.

Example: Failover clustering services, Replication, parallel create Index, Log shipping, Indexed views, federated database servers etc.,


If you need more help just goto Books online sql server 2000 goto word "Editions of SQL Server 2000 "



With Regards
Sreenivas Reddy B
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-30 : 01:14:58
replication works in standard edition

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -