AnsweredAssumed Answered

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

Question asked by sdeneice123 on Jan 14, 2020

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

Outcomes