July 26, 2002 at 9:00 am
We mistakenly installed the Enterprise version of SQL Server 2000 on one of our servers and we are going to have to uninstall it and reinstall the Standard version. (We are trying to make sure we are completely compliant.)
This server already has a number of users and databases. I am just trying to get some opinions on the best way to move the current databases to the new installation. Should I detach and attach? Can I even do that with the system databases (master, model, msdb)? Should I just do a clean install of the Standard Edition and restore all databases, system and user, from our current setup?
I have had problems in the past moving from one server to another so I am just trying to do this in the best way. Most of my problems have been with logins and database users not matching up.
Thanks for any and all help.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
July 26, 2002 at 11:27 am
detach, backup to tape or another server, reinstall, and then attach.
Steve Jones
July 26, 2002 at 12:04 pm
Can I do this with the system databases? Will SQL Server let me detach the master database then attach a different one?
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
July 26, 2002 at 12:20 pm
Not sure. Especially if you are changing editions. I suspect you need to export the logins somehow and reimport them. Not sure you need anything else.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply