topic Allocating more space on SQL Server for an enterprise GDB? in ArcGIS Enterprise Questions

Allocating more space on SQL Server for an enterprise GDB?

Brownschuh — Thu, 08 Jun 2017 16:57:03 GMT

Currently our organization has 2 databases on our SQL server; one housing vector data and the other housing raster. If I log into SQL management studio and check the properties for each of the databases, I can see total size as well as available space. Vector appears to have consumed half of the space available whereas Raster is almost all used up; this has me a bit worried.

Is there a way to allocate more space for an enterprise geodatabase? Is this even possible in SQL management studio?

At the moment we are not adding any additional files to the Raster database, but later down the line we will probably acquire more aerial imagery/lidar/etc. Just trying to prepare for the future the best I can.

P.S. We are currently using SQL 2012 (11.0.2218) and ArcGIS v10.4.1

Re: Allocating more space on SQL Server for an enterprise GDB?

JakeSkinner — Thu, 08 Jun 2017 17:50:06 GMT

Hi Scott,

Yes, you can do this in SQL Server Management Studio (SSMS).

Increase the Size of a Database | Microsoft Docs

Also, for the Raster database you may want to consider using mosaic datasets. This will save you a lot of storage as the mosaic dataset simply references the imagery from disk rather than loading into the database.

Re: Allocating more space on SQL Server for an enterprise GDB?

RandallWilliams — Thu, 08 Jun 2017 17:51:10 GMT

If you have available space on your partition, these instructions should help you to allocate additional space with SQL Server Management Studio.

https://technet.microsoft.com/en-us/library/ms175890(v=sql.105).aspx

Re: Allocating more space on SQL Server for an enterprise GDB?

RebeccaStrauch__GISP — Thu, 08 Jun 2017 17:55:58 GMT

I would second Jake's suggestion about moving the raster to a mosaic database if possible. Much less overhead and easier to manager. However, if you are going to publisher services directly from the mosaic, you will need Image Server (extension, pre 10.5) besides the core ArcGIS Server.

Re: Allocating more space on SQL Server for an enterprise GDB?

Brownschuh — Thu, 08 Jun 2017 18:06:13 GMT

Ok cool, I'm glad to hear it's possible to increase the size of a database. Going to give those links a look at and see what happens.

Honestly I am a little surprised that we've used up as much space as we have because we currently use mosaic datasets for all our imagery.

Re: Allocating more space on SQL Server for an enterprise GDB?

Brownschuh — Fri, 09 Jun 2017 12:23:44 GMT

So I checked out both of those links that Jake & Randall provided ... it worked!

Honestly I thought the process would be a bit more involved then simply right clicking the database, selecting properties, putting a new size value in, and hitting OK. Not that I'm complaining, I'm just happy it was easy procedure.