topic Moving SDE Geodatabase to new folder in Data Management Questions

Moving SDE Geodatabase to new folder

TimHayes — Sun, 30 Sep 2012 23:43:48 GMT

In the Database Properties Window, Name; it shows:

C:\Users\myname\AppData\Roaming\Esri\Desktop10.1\ArcCatalog\GISDATASTORAGE.sde

No one else is using the geodatabase; no one else is logged onto it. My Map Services are not connected to it. I just created it. I have Feature Datasets and Feature Classes with data stored in it.

How do I go about changing the location of GISDATASTORAGE.sde? I would like to move it to a Folder on my E: drive. I want to change the location to E:\SDE_Geodatabases\GISDATASTORAGE.sde

Re: Moving SDE Geodatabase to new folder

VinceAngelo — Mon, 01 Oct 2012 00:49:04 GMT

That really doesn't sound like an ArcSDE geodatabase -- SQL-Server usually reserves the suffixes
on database files (and they come as a set .mdf/.ldf) -- but if it is, then you need to use SQL-Server
to detach the database, move it (and its companion) using the filesystem, then reattach the mdf.
The .sde file is more than likely just the connection file to the database, so you'll probably want to
look at the datafiles' names (and location) before you detach the database.

- V

Re: Moving SDE Geodatabase to new folder

TimHayes — Mon, 01 Oct 2012 03:05:50 GMT

That really doesn't sound like an ArcSDE geodatabase -- SQL-Server usually reserves the suffixes
on database files (and they come as a set .mdf/.ldf) -- but if it is, then you need to use SQL-Server
to detach the database, move it (and its companion) using the filesystem, then reattach the mdf.
The .sde file is more than likely just the connection file to the database, so you'll probably want to
look at the datafiles' names (and location) before you detach the database.

- V

I was confused. I was in ArcCatalog and right clicked on my SDE Geodatabase, chose Properties, then under Name the above referenced path came up. This looks like a pointer? it is not the actual database. I found that my SDE Geodatabase indeed does reside in SQL Server on my E: drive just how I want it to. No problems. Thanks.

Re: Moving SDE Geodatabase to new folder

AsrujitSengupta — Fri, 05 Oct 2012 02:14:20 GMT

"C:\Users\myname\AppData\Roaming\Esri\Desktop10.1\ArcCatalog\GISDATASTORAGE.sde"

The above path is the location where the geodatabase connection files for ArcCatalog are stored by default. You can even copy paste the "GISDATASTORAGE.sde" connection file and place it in your desired folder on any drive of your choice and then connect to it from ArcCatalog.