Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
New Member
bobbyh
Posts: 1
Registered: ‎08-06-2012
Message 1 of 2 (657 Views)

Extending data store extents SQL 2008

657 Views, 1 Replies
12-03-2012 11:52 AM

When I created my database I set the Data Store Extents to an area Sufficient for my project, but the project has changed and I need to extend the area of the data store. Is there a way to change the Extents or does it matter if I’m outside of my data store extents. Thanks

Valued Mentor
jackie.ng
Posts: 279
Registered: ‎10-06-2008
Message 2 of 2 (654 Views)

Re: Extending data store extents SQL 2008

12-03-2012 05:34 PM in reply to: bobbyh

Data store extents in SQL Server 2008 mainly affects the spatial indexes that gets created for geometry columns.

 

Is this a database with FDO metadata tables (they start with f_ ) or is it just a regular one?

 

If it's a regular database, just modify the bounds of the spatial index on that geometry column in question, otherwise if it has FDO metadata tables, you may have to also change the bounds in one of the f_ tables (it'd be the one relating to spatial contexts)

 

- Jackie

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.