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 |
|
saurabh811
Starting Member
33 Posts |
 Posted - 2008-06-13 : 16:06:01
|
| Hi all,i have production database running on enterprise edition 2005 and now i want to downgraded EE to standard edition 2005 because of license issue.i have sql server jobs(use for reporting purpose),users and one small database on server.so what is the best way to downgrad from EE to SE.thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-13 : 16:41:14
|
| You will have to uninstall and install Standard:Make sure you copy logins with http://support.microsoft.com/kb/918992and script all jobs Backup all databases and reporting database as well. |
 |
|
|
|
|
|
Down grading SQL Server 2005 from EE to Standard