topic Re: Backup Geodatabase but without Rasters in Geodatabase Questions

Backup Geodatabase but without Rasters

DiegoLlamas — Wed, 09 Jan 2019 18:56:37 GMT

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‌

Re: Backup Geodatabase but without Rasters

George_Thompson — Wed, 09 Jan 2019 20:28:33 GMT

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.

Re: Backup Geodatabase but without Rasters

MichaelVolz — Wed, 09 Jan 2019 20:31:45 GMT

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?

Re: Backup Geodatabase but without Rasters

Asrujit_SenGupta — Thu, 10 Jan 2019 03:51:21 GMT

Or probably check Differential Backups (SQL Server) - SQL Server | Microsoft Docs