Post reply

Uninstalling SQL Server Enterprise and re-installing with Standard Edition

  • September 13, 2006 at 4:58 pm

    #94547

    Hi,

    I am new to the group. I am new to SQL Server 2000. I just found out that I need to uninstall SQL Server 2000 Enterprise Edition with SQL Server 2000 Standard Edition.

    Has anybody done this and what is the steps involved? Can it be done with the database intact?

    Thank you in advance for any feedback.

     

    Thanks.

  • September 15, 2006 at 7:28 am

    #660691

    The obvious first step would be to back up everthing...

    You should then be able to detach your databases.  Then you could uninstall Enterprise ed and reinstall Standard ed. Reattach your databases and you should be all set.

    Remmeber that any DTS jobs etc... would be stored in MSDB, so if you are doign any of that make sure that that database is backed up as well.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 15, 2006 at 11:05 am

    #660788

    I'd also look into bringing over the Logins.  They are stored in the Master Database.  I don't think you would be able to restore or attach the old Master DB (I could be wrong). 

    If they are all Windows Logins it would be different (easier?) than if you have some SQL Logins as well.

    Steve B.

  • September 15, 2006 at 11:09 am

    #660791

    You can script out all fo the logins...  Then just run that script in QA... Piece of cake.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • September 15, 2006 at 1:47 pm

    #660816

    Hi All,

     

    Thanks for the reply. Regarding restoring system databases, I could copy the data/log files then un-install Enterprise and re-install Standard edition. After Standard is installed, copy data/log files back then you would have everything intact? Yeah? Of course you have to make sure the instance is down while you are copying system database files and then run dbcc checkdb and make sure it is clean.

    Comments?

    Thanks,

    Kiri

     

     

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply