is there a way to limit the default mdf and ldf values when creating an enterprise geodatabase in sql

01-14-2020 02:37 PM
New Contributor

When using the Create Enterprise GeoDatabase tool, the default is a 500 MB mdf and 125 MB ldf.  Is there a way to change this?   I have inventoried all of our sde databases, and only 1 is larger than 500 MB and that is due to a larger number of attached images.  All the rest are less than 100 MB.  The problem is, once you set the mdf/ldf file size, you cannot make them smaller.  You can only ever shrink them to 500/124 MB.  I am trying to create a tool that will create a geodatabase, and import a template schema,  but do not want that size.

I know you can create the db is SQL, then use the Enable SDE tool, but I was trying to find a way to create a tool that would leverage several other tools without having to create the db in SQL first

0 Kudos
0 Replies