Re: MSDE vs MS SQL

From: JoeyDBA (JoeyDBA_at_yahoo.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 09:34:44 -0500

Sam,
    Yes, you can uninstall both versions. Then you can re-install SQL2000 as
the default instance. I would advise a couple of things first:
1) Be sure to backup your databases.
2) Detach any databases that you want to keep. That way, once you've
reinstalled SQL2000 as the default, then you can reattach the databases.
You'll have to reset or recreate your users.

HTH.

"Sam" <cybersam88@hotmail.com> wrote in message
news:OZCu$wFhEHA.3320@TK2MSFTNGP11.phx.gbl...
> There are two SQL running at my server as follows:
> - MSDE
> - MS SQL Server 2000
>
> Issue
> - MSDE is act as core SQL Server which limited to 2GB per database size
>
> Info
> - Both SQL is running on MS Windows 2003 Server platform
> - MS SQL 2000 Analysis Service also installed and using MSDE database
>
> Inquiry
> - May I uninstall MSDE and MS SQL Server 2000, please?
> - Any issue / impact after I uninstall all?
>
> Question
> - I re-install MS SQL Server 2000 instead of MSDE because wrongly restore
> database at MSDE
>
> Please help.
>
>

Relevant Pages

  • Re: SQL Server Desktop Engine
    ... I just run the EXE file to update my engine and databases rather than ... detach, uninstall, reinstall, and attach my data? ... > I would detach your user databases, uninstall MSDE, and get MSDE Release A ...
    (microsoft.public.sqlserver.server)
  • Do I stand a chance of being sucessful?
    ... I understand the concepts of basic computer ... management, databases, networks, and programming. ... in Sequel or MSDE. ... The current club management software is about 4 years old, ...
    (microsoft.public.sqlserver.msde)
  • Cannot insert explicit value for identity...
    ... I am developing an integration process between two databases. ... The main database is the SQL Server, the MSDE will contain a really ...
    (comp.databases.ms-sqlserver)
  • Re: Logging to MSDE
    ... > MSDE is a performance limited version of MS-SQL. ... You will need to use something else to setup the databases. ... > So with that in mind setting up ISA for MSDE should be identical to ... setting it up for SQL 2000. ...
    (microsoft.public.isa.configuration)
  • Re: Prevent Viewing on worksheet
    ... MSDE isn't an Office component. ... your main goal were getting more people to use databases rather than ... DBA in his/her right mind would even dream of giving every employee ... Pipe dream. ...
    (microsoft.public.excel)
Loading