Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing MSDE Database Location
Message
De
08/10/2001 10:32:58
George Simon
GS Data Technologies, LLC
Cincinnati, Ohio, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00565066
Message ID:
00565486
Vues:
26
>How do I move the default database(s) and tell MSDE where to look for them?

Evan,

The following information is true for the the SQL Server 7.0 version of MSDE. I think it's the same for the SQL Serer 2000 version.

You may have to uninstall MSDE and start over to make sure the default databases (such as MASTER) are relocated.

If you are truly installing MSDE (as opposed to the Developer version of SQL Server) then the key to configuring the installation is the unattend.iss file. Unattend.iss is a text file. Look for the keyword:

[SetupTypeSQL-0]

Under that keyword you will find the following settings:

szDir=C:\MSSQL7
szDataDir=C:\MSSQL7

You can change these settings to control where SQL Server and the data are installed.

There is more you can control with the unattend.iss file than I've listed here so it's worth your time to read more about this file.

HTH
George Simon, MCP
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform