Re: Uninstalling MSDE doesn't delete non-default directories

From: SloCoach (russell_NO_n_SPAM_wyatt_PLEASE__at_yahoo.com)
Date: 02/02/04


Date: Tue, 3 Feb 2004 09:28:24 +1100


"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:bvm1pa$td7ib$1@ID-207518.news.uni-berlin.de...
> hi Russell,
> "SloCoach" <russell_NO_n_SPAM_wyatt_PLEASE_@yahoo.com> ha scritto nel
> messaggio news:%23$l7vpS6DHA.3548@TK2MSFTNGP11.phx.gbl...
> > I am installing MSDE 2000 sp3a from an InstallShield setup. I am
finding
> > that if I install to the default directories ("C:\Program
Files\Microsoft
> > SQL Server\...) the uninstall cleans up after itself and removes the
> > relevant directories. However, I also wish to be able to install to
other
> > (non-default) directories lets say C:\MSSQL\ for instance (I do this by
> > having my InstallShield script write into the Setup.ini file for
TargetDir
> > and DataDir before launching the setup for MSDE). First install goes
fine.
> > If I then uninstall (from Add/Remove Programs) and install again the
> > subsequent install fails. Inspection of the verbose log shows that the
> data
> > directory from the previous setup remains and this is causing the
failure.
> > As I said before, if I use the default dirs these get removed. Is there
> any
> > way I can ensure MSDE setup cleans up after itself.
> >
> > Regards
> >
> > Russell Wyatt
> >
> >
>
> actually I'm not completely sure MSDE uninstallation provides complete
> clean-up of the data directory...
> that's woul'd imply that all user's databases will be erased as well...

You are correct. It doesn't clear the users' databases. This is fine as my
installer reattaches the users' database on reinstallation and I put the
data files in a seperate branch so that MSDE doesn't create double nested
paths when reinstalling.

> but
> you can chek the HKLM\Software\Microsoft\MSSQLServer\Setup
> SQLDataRoot registry key
> (HKLM\Software\Microsoft\Microsoft SQL Server\instance_name\Setup for
named
> instances)
> in order to get the actual default folder for user's databases and provide
> accordingly [hopefully move that files :-)) ]
> I think InstallShield can handle this... checking a registry key, make
sure
> on the file system that folder exists and move it or erase it...
>
Yup I'm sure it can too, I was just expecting the MSDE installer to do it
itself as it does when in Program Files which of course would be more
elegant. Of course if everything was straight forward we would all be out of
a job wouldn't we :-)

Thanks for your response Andrea.

Russell



Relevant Pages

  • Re: Multi-Boot and sharing MSDE data?
    ... I would like to install ... I would like to share a common location for the MSDE ... > Is there any way to share a DataDir location? ... databases, so you do are not allowed to share the DataDir among instances... ...
    (microsoft.public.sqlserver.msde)
  • Re: Wrong MSDE installed
    ... That is the command line to install a new default instance. ... This will upgrade the existing instance but do nothing to get SBS Monitoring and Sharepoint installed. ... They use WMSDE not MSDE. ... those folders are as you say on my SBS 2003 server that has been upgraded to SP1. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Great Plains problem - NOT SOLVED :(
    ... It doesn't matter if the new instance of MSDE is ... but I now have a new instance of MSDE working and the SBS backup also ... install a new instance the install quit with an error. ... server for the customer before they install it on their server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Wrong MSDE installed
    ... those folders are as you say on my SBS 2003 server that has been ... The setup wizard will not run because of the older version of MSDE. ... If I need to install an MSDE instance I always do it from the ...
    (microsoft.public.windows.server.sbs)
  • Re: Wrong MSDE installed
    ... Gregg Hill ... I was able to run the MSDE SP3a update using the following command line. ... I was able to run the SBS setup wizard. ... install re-install SharePoint, Administration, and Monitoring. ...
    (microsoft.public.windows.server.sbs)

Loading