Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-08-19 : 16:13:35
|
| Folks:I recently migrated all of our SQL 2000 SP4 databases from one server to new server (new hardware). After the successful migration I realised that instead of installing SQL Enterprise Edition, I installed SQL Standard Edition. The old server had SQL Enterprise Edition. What are my options If I have to move it back to Enterprise Edition?Do I need to install SQL again? If so, can I detach and attach databases? Any help and suggestions is appreciated.Thanks ! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-19 : 17:10:51
|
| Just run sql2k enterprise edition installation again, it'll migrate standard edition to enterprise edition. |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-08-20 : 09:42:32
|
| Will it also migrate the databases? or Do I have to detach the databases first? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:17:03
|
| Don't have to. |
|
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-08-28 : 15:01:44
|
| What will happen to the master database syslogins and msdb jobs? Will everything stay as is when I run the sql2K enterprise edition?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 21:52:34
|
| Not affected. |
|
|
|
|
|
|
Enterprise Edition and Standard Edition SQL 2000