Post reply

Reinstall Of SQL?

  • August 7, 2003 at 10:00 am

    #59351

    We accidentially installed SQL Develper instead of the standard edition for 2000, but there are active DB's in use on it.

    1)Will we run into an issyes running developer instead of the full version

    2)If a reinstall is required if you install SQL full on top of the developer edition will it keep all the settings or will it reset everyhting?

    Thanks!

  • August 7, 2003 at 10:27 am

    #469039

    In term of capacity, There is no problem. But you shouldn't use developer edition for your production system.

    Before reinstall, backup all your databases and restore them after the reinstall. You will be fine.

  • August 7, 2003 at 10:34 am

    #469041

    Thanks I wil go ahead and do that. "Hopefully" no one will notie it is still early. 🙂 I also wanted to know "why" one should not run developer in a production enviorment? On the other computers I used the same tools to install the client access utilities but that should not make a difference right? I also imagine I will have to reinstall SP.

  • August 7, 2003 at 10:50 am

    #469043

    quote:

    I also wanted to know "why" one should not run developer in a production enviorment?

    http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc

    quote:

    On the other computers I used the same tools to install the client access utilities but that should not make a difference right?

    It shouldn't as long as you keep same server name and TCP port setting.

    quote:

    I also imagine I will have to reinstall SP.

    What SPs?

  • August 7, 2003 at 10:54 am

    #469044

    service pack 3

  • August 7, 2003 at 10:57 am

    #469046

    You should. Plus MS03-031.

  • August 7, 2003 at 11:08 am

    #469049

    in need of a good comparison chart

    is sql 2000 replaced by 7.0? or is there 2003 in the works or have they decided to go to propper version numbers?

    Suggestion for forum, change tab order for forum mesage so it it goes username, password textbox, lower check boxes then post new reply then others & then formating buttons. I dont really care for the formatting buttons but that is just my opinion.

  • August 7, 2003 at 11:24 am

    #469054

    SQL 2000 replaces SQL 7.0.

    Hidden in the SQL Server 2000 copyright is the version # 8.00.00 etc.....

    So...SQL Server 2000 is really SQL Server 8.0

    -SQLBill

  • August 8, 2003 at 9:49 am

    #469215

    Developer is upgradeable to Enterprise Edition. Check BOL. No backup/restore/uninstall would be needed.

Viewing 9 posts - 1 through 8 (of 8 total)

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