August 9, 2004 at 7:43 am
How easy is it to down-grade SQLServer 2000 from Enterprise edition to the standard edition?
Are there any risks involved?
If yes, what are these risks and what could I do to minimise them?
August 9, 2004 at 8:56 am
according to microsoft docs you can't.
what you could do though is back up your user databases and uninstall sql server - then install sql standard and restore your databases.
proboably best to do a trial restore 1st to a test server.
MVDBA
August 9, 2004 at 10:33 am
You don'tneed to restore the dbs. Use sp_help_revlogin (from MS) to script logins. Uninstall. reinstall, and attach your databases. Run script to load logins.
August 9, 2004 at 2:10 pm
Make sure to script the jobs and also DTS packages. If you search this site, there is how to move system databases with scripts since you can't backup and restore the system databases.
I am sure you already went over the difference between Ent ed and Std Ed if you haven't go to http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp
Other then that, I don't see any risks if you don't need those features that Enterprise version has it like, cluster, large memeory, logshipping, etc.
August 10, 2004 at 7:31 am
I would suggest that you do an inventory of any INDEXED VIEWS that you have on your existing Enterprise Edition install. Make sure that your implementation code is specifically referencing those INDEXED VIEWS, as the query engine in Std Edition won't automatically take advantage of them.
Corie Curcillo
MCT, MCDBA, MCSD
August 10, 2004 at 1:49 pm
Not sure why you want to "downgrade" but if it is because of licensing costs, you might want to look into this (and get it in writing): we were once told by our Microsoft rep that we could have Enterprise installed and continue to use it only paying for standard as long as we weren't using any of the Enterprise features.
Good luck.
Francis
Francis
-----------------
SQLRanger.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply