Post reply

Upgrading MSDE 2000 to SQL 2000 Standered

  • September 11, 2006 at 3:41 am

    #367323 

    Hi,is it possible to upgrade MSDE 2000 to SQL 2000 Standered. If so what is the simplest and easist wayThanksb

  • September 12, 2006 at 12:11 am

    #659800

    Upgrading from MSDE 2000 to any other version of 2000 should be as simple as detaching and attaching.  One thing that you should look out for is that many MSDE applications are written without regard to separation of data and logs.  Upgrading to a higher edition also enables many other features/options to be considered.

  • September 14, 2006 at 1:51 am

    #660309

    Hi

    In MSDE autoclose is turned on automatically and you'd better set it to off in SQL 2000.

    JP

  • September 14, 2006 at 10:54 am

    #660461

    Backup and Restore

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

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