Backup Geodatabase but without Rasters

284
3
01-09-2019 10:56 AM
DiegoLlamas
Esri Contributor

Hello,

I have a SQL Server geodatabase, in this geodatabase I also have several rasters in it. Using automatic backup option it do a full backup with the 250 GB of rasters. Is it possible to do a full backup but telling SQL do not backup my Rasters?

Thank you very much for your help!

Diego Llamas

George Thompson's Blog

0 Kudos
3 Replies
George_Thompson
Esri Frequent Contributor

You could look into SQL Server Import and Export tools.

Exporting Selected tables from a SQL Database – Microsoft Team Foundation Server Support 

Start the SQL Server Import and Export Wizard - SQL Server | Microsoft Docs 

You would have to make sure that you exclude all the appropriate raster tables. This may be a mess.

Can you export those rasters to disc then reference them in a mosaic dataset? If you can do that, it would probably have quite a few benefits for the geodatabase.

--- George T.
MichaelVolz
Esteemed Contributor

I would concur with George Thompson as my org used to have rasters in SDE, but we have moved them to disc and reference the files in a Raster Mosaic Dataset.

Are you currently using the Image Server role of ArcGIS Enterprise?

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor
0 Kudos