topic is there a way to limit the default mdf and ldf values when creating an enterprise geodatabase in sql in Admin Tools Questions https://community.esri.com/t5/admin-tools-questions/is-there-a-way-to-limit-the-default-mdf-and-ldf/m-p/850192#M85 <HTML><HEAD></HEAD><BODY><P>When using the Create Enterprise GeoDatabase tool, the default is a 500 MB mdf and 125 MB ldf.&nbsp; Is there a way to change this?&nbsp; &nbsp;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.&nbsp; All the rest are less than 100 MB.&nbsp; The problem is, once you set the mdf/ldf file size, you cannot make them smaller.&nbsp; You can only ever shrink them to 500/124 MB.&nbsp; I am trying to create a tool that will create a geodatabase, and import a template schema,&nbsp; but do not want that size.</P><P>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</P></BODY></HTML> Tue, 14 Jan 2020 22:37:11 GMT ScottDeNeice 2020-01-14T22:37:11Z is there a way to limit the default mdf and ldf values when creating an enterprise geodatabase in sql https://community.esri.com/t5/admin-tools-questions/is-there-a-way-to-limit-the-default-mdf-and-ldf/m-p/850192#M85 <HTML><HEAD></HEAD><BODY><P>When using the Create Enterprise GeoDatabase tool, the default is a 500 MB mdf and 125 MB ldf.&nbsp; Is there a way to change this?&nbsp; &nbsp;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.&nbsp; All the rest are less than 100 MB.&nbsp; The problem is, once you set the mdf/ldf file size, you cannot make them smaller.&nbsp; You can only ever shrink them to 500/124 MB.&nbsp; I am trying to create a tool that will create a geodatabase, and import a template schema,&nbsp; but do not want that size.</P><P>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</P></BODY></HTML> Tue, 14 Jan 2020 22:37:11 GMT https://community.esri.com/t5/admin-tools-questions/is-there-a-way-to-limit-the-default-mdf-and-ldf/m-p/850192#M85 ScottDeNeice 2020-01-14T22:37:11Z