SQL 2000 Enterprise replication to SQL 2000 STANDARD

Posted on 2009-04-21
Last Modified: 2012-05-06
We have a server running SQL 2000 Enterprise for approx 200 users. We would like to replicate the server but don't want to have to buy Enterprise.

My question is: Can you replicate from SQL 2000 Enterprise to SQL 2000 STANDARD considering the users. ( we will be buying standard 2005 and using downgrade rights. )

Question by:pbrane
    LVL 46

    Accepted Solution

    Hi pbrane,

    See if this helps

    Good Luck!

    LVL 44

    Assisted Solution

    by:Vitor Montalvão
    What you mean with replicating databases?
    It's SQL Server native replication or moving databases from one server to another?
    You can do both, just remember that Standard Edition don't have all features from Enterprise Edition. For example Standard Edition are limited to 4 CPU and 2GB RAM.

    Good luck
    LVL 4

    Author Comment

    Thanks for the input tbsgadi but the article discusses different version ie 2000 with 2008 etc but I am discussing same version.

    Vmontelvao we want to create replication (copy) to a hosted SQL server off-site for fault tolerance. I will consider what you've said and find an article describing further differences.
    LVL 4

    Author Comment

    Bugger actually tbsgadi  you article is more relevant as I wont get downgrade rights to 2000!!!!!
    Any objections on splitting the points?

    LVL 46

    Expert Comment

    No objection!

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now