Changing from SQL Server 2000 Enterprise edition to Standard edition

  • Hello all,

    Here I need some help or suggestions for the following topic...

    I am using SQL server 2000 enterprise edition installed on the machine. Now I wanted to change the edition from enterprise to standard.

    There are around 4 user databases exists on the server.

    What are the areas I have to take care while doing this? Could I do as normal installation?

    No log shipping implemented on the server.

    Your suggestions would be very helpful to me.

    Thanks in advance.

  • Backup the user databases. Save DTS packages to files. Script logins, jobs, linked servers. Uninstall Enterprise. Install Standard. Run scripts to create logins, jobs, linked servers. Restore user databases. Open and resave DTS packages.

    You could also install Standard as a named instance and move everything from the Enterprise instance before uninstalling it.

    Greg

  • If your databases are huge, you may consider to use attach/detach approach.

  • Thanks a lot for the information.

    I would try to implement the steps.

    Bagath

  • I am curious as to why you are moving from Enterprise Edition to Standard Edition if it is already paid for?

    Steve

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply