Post reply

Upgrading SQL Server

  • December 1, 2004 at 3:25 pm

    #182965

    Very new to SQL Server. We have software, that when upgraded came bundled with SQL Server 2000 MSDE. Now, due to the size of our database, I am told that we have to upgrade to Standard Edition. My question? Is this something that will require a master's degree in IT and 40 hours of time? Or can a weekend hack handle it?

    Thanks for your patience

  • December 2, 2004 at 6:36 am

    #532177

    Nora,

    First, install the client tools so you have Enterprise Manager.

    Simply detach the current database from SQL MSDE.

    Install the new SQL Server version, and attach the database file (MDF).

     

    Robert

  • December 2, 2004 at 7:35 am

    #532189

    Actually you only have to install the standard version of SQL2000. It will see the MSDE2k instance running and update it. The installation will ask you if you want to upgrade it when it runs.

    Of course, Backup, Backup, Backup

    Don

  • December 2, 2004 at 7:43 am

    #532192

    I was making an assumption that they did not install the MSDE on a server or that they ended up buying a server to put SQL Server on.

    But, Don is correct.  If you installed MSDE on the server you are going to run SQL Server on, all you need to do is what he said.  Although, I would detach the database and make a copy of it, then reattach it.

  • December 2, 2004 at 7:59 am

    #532199

    Thanks to you both. Sounds like I can handle this one

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

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