February 26, 2008 at 12:03 am
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.
February 26, 2008 at 10:17 am
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
February 26, 2008 at 10:19 am
If your databases are huge, you may consider to use attach/detach approach.
February 27, 2008 at 5:12 am
Thanks a lot for the information.
I would try to implement the steps.
Bagath
February 28, 2008 at 8:54 am
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