The size of mdf file is much bigger than its gdb file,

1184
5
04-09-2017 11:12 AM
JamalNUMAN
Esteemed Contributor

The size of mdf file is much bigger than its gdb file,

 

As all the content of mdf file is exported (or imported) to a gdb, the size drops dramatically. The size of mdf is 8GB while its corresponding gdb is 200MB!!!

 

Then how to “clean” the mdf file so that it gets as small as the gdb?

 

Thank you

 

Best

 

Jamal

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
5 Replies
JoshuaBixby
MVP Esteemed Contributor

Read up on sp_spaceused (Transact-SQL), paying particular attention to how the categories of space are defined.

Shrinking an enterprise database (geo- or otherwise) can cause a lot of logging, disk I/O, and other non-desirable behaviors.  Given the size of today's local storage options, I am not sure it is worth pursuing.  If you do pursue it, make a backup before you try it.

Another thing to consider is that the geodatabase model is implemented quite a bit differently in an enterprise geodatabase versus a file geodatabase.  File geodatabases may support the data models of the geodatabase, but they don't support all of the functionality like versioning.

Have you looked at the state of your geodatabase?  How much data is tied up in add and delete tables?  I would look at reconciling and compressing the geodatabase before shrinking the enterprise geodatabase that hosts the geodatabase.

JamalNUMAN
Esteemed Contributor

Are there any powerful tools in Pro that can purge the mdf data?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
JoshuaBixby
MVP Esteemed Contributor

There is nothing new in Pro that I am aware of.  What have you tried from last time you asked, and what were the results?

0 Kudos
George_Thompson
Esri Frequent Contributor

The MDF file is managed by SQL Server not ArcGIS. I would also review the post that @JoshuaBixby  mentioned. 

--- George T.
JamalNUMAN
Esteemed Contributor

Thank you guys for the input

Best

Jamal

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos