Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing MSDE Database Location
Message
From
08/10/2001 10:32:58
George Simon
GS Data Technologies, LLC
Cincinnati, Ohio, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00565066
Message ID:
00565486
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform