Default location for the created enterprise geodatabase,

978
6
03-28-2013 02:30 PM
JamalNUMAN
Legendary Contributor
Default location for the created enterprise geodatabase (*.mdf) file on the hard drive,

When an enterprise geodatabase (*.mdf) is created from the ArcGIS, then it is saved by default on the location below

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

[ATTACH=CONFIG]23058[/ATTACH]

Is there a way to set this path to be D:\ (for example)?


If the database is created from the sql server, then one can choose the location of the database

[ATTACH=CONFIG]23059[/ATTACH], [ATTACH=CONFIG]23060[/ATTACH]

Then how the location of the database can be chosen if it is created from the ArcGIS?


Thank you

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
6 Replies
MandarPurohit
Esri Contributor
Hi Jamal,

Since 'Create Enterprise Geodatabse' tool is designed to create the datafiles at the default location, you will need to create the database in SQL Server providing the custom location and then run 'Create Enterprise Geodatabase'.

In this case the tool will detect the existing database and will proceed with the remaining tasks of creating the geodatabase.

User has privileges required to create database objects.
Database already exists.
Geodatabase admin user created.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Created geodatabase tables and stored procedures.
Finished creating geodatabase schema.
Succeeded at Thu Mar xx xx:00:11 2013 (Elapsed Time: 16.00 seconds)


In case the database and the admin user (with appropriate permissions) are already created, you can use the "Enable Enterprise Geodatabase" tool.

Based on the description from webhelp:

Creating a database and geodatabase in SQL Server

"Create a database (500 MB) and log file (125 MB) in the default SQL Server location."
0 Kudos
by Anonymous User
Not applicable
Original User: Jamal432@gmail.com

Hi Jamal,

Since 'Create Enterprise Geodatabse' tool is designed to create the datafiles at the default location, you will need to create the database in SQL Server providing the custom location and then run 'Create Enterprise Geodatabase'.

In this case the tool will detect the existing database and will proceed with the remaining tasks of creating the geodatabase.

User has privileges required to create database objects.
Database already exists.
Geodatabase admin user created.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Created geodatabase tables and stored procedures.
Finished creating geodatabase schema.
Succeeded at Thu Mar xx xx:00:11 2013 (Elapsed Time: 16.00 seconds)


In case the database and the admin user (with appropriate permissions) are already created, you can use the "Enable Enterprise Geodatabase" tool.

Based on the description from webhelp:

Creating a database and geodatabase in SQL Server

"Create a database (500 MB) and log file (125 MB) in the default SQL Server location."


Many thanks for the answer,

Then I�??m wondering if there might be kind if settings at the SQL server (for the customized location of created database) that will affect the created enterprise geodatabased from the ArcGIS to be stored at that location.

Sure any database created from the sql server can be enabled to be geodatabase.

Best

Jamal
0 Kudos
VinceAngelo
Esri Esteemed Contributor
*All* database vendors have unfortunate default data locations.  I *always*
manually create databases, so I *always* have the opportunity to specify
where I want my datafiles.

If you want Microsoft to change how their default storage location works, you
should probably take that up with them directly.

- V
0 Kudos
by Anonymous User
Not applicable
Original User: asrujit

Jamal,

Just FYI,

even if you change the default data location of the Database files in SQL Server for a particular Instance, the newly created geodatabase using ArcGIS interface will still have its data files in the default location set by Microsoft.

So, the only option will be to create the database in SQL Server first at your preferred location, and then use the enable geodatabase option to convert it into a geodatabase.

Regards,
0 Kudos
JamalNUMAN
Legendary Contributor
Jamal,

Just FYI,

even if you change the default data location of the Database files in SQL Server for a particular Instance, the newly created geodatabase using ArcGIS interface will still have its data files in the default location set by Microsoft.

So, the only option will be to create the database in SQL Server first at your preferred location, and then use the enable geodatabase option to convert it into a geodatabase.

Regards,


Thank you Asrujit for the answer,

This is what I wanted to know.

appreciated

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
by Anonymous User
Not applicable
Original User: Jamal432@gmail.com

*All* database vendors have unfortunate default data locations.  I *always*
manually create databases, so I *always* have the opportunity to specify
where I want my datafiles.

If you want Microsoft to change how their default storage location works, you
should probably take that up with them directly.

- V


Many thanks Vince,

In the SQL server, one can choose the destination for the created database! The issue is when the geodatabase is created from the ArcGIS! There is no option to specify it (destination)

Best

Jamal
0 Kudos