How To: Use ArcSDE with SQL Server 2008 R2 Express to enable a 10 GB storage limit
Microsoft SQL Server 2008 R2 Express Edition has a 10 GB per database size limit, instead of the 4 GB per database limit that was imposed for earlier releases of SQL Server Express Edition.
Instructions provided describe how to use SQL Server 2008 R2 Express with Advanced Services with ArcSDE for SQL Server Express to create a 10 GB geodatabase.
ArcGIS Desktop 10, ArcGIS Engine 10, and ArcGIS Server 10 include an installation of SQL Server 2008 Express with Advanced Services, which has a 4 GB database size limit. To use SQL Server 2008 R2 Express with Advanced Services and a 10 GB database size limit, follow the procedure below.
Download SQL Server 2008 R2 Express with Advanced Services from Microsoft's Web site. See the link in the Related Information section at the bottom of this article.
Install SQL Server 2008 R2 Express with Advanced Services and create a SQL Server Express instance, following Microsoft instructions. Run the SQL Server Express service under the Built-in Local System account.
A. Start the SQL Server Configuration Manager. B. Right-click the SQL Server Express 2008 R2 instance, and click Properties. C. Select the Log On tab on the Properties dialog box and make sure the service is logging on as Local System. If it is not, select Local System from the Built-in account drop-down list and click OK. The service restarts under the new account.
Once the SQL Server 2008 R2 Express instance is configured, start the ArcSDE for SQL Server Express installation from the ArcGIS Desktop media or the ArcSDE for SQL Server Express installation from the ArcGIS Server (Workgroup) media. When the installation wizard opens, uncheck the option to install SQL Server Express, but leave the option to Enable geodatabase storage on SQL Server Express checked and click Next.
Choose the SQL Server 2008 R2 Express instance that is already set up from the SQL Server instance name drop-down list. Enter a Windows login to be the instance administrator, then click Next. This enables the SQL Server 2008 R2 Express instance for ArcSDE geodatabase storage.
If using the Workgroup Edition of ArcSDE for SQL Server Express, it is then necessary to authorize. This is not required if using the ArcSDE for SQL Server Express installation that comes with ArcGIS Desktop or ArcGIS Engine.
Now a Database Server connection can be made to the SQL Server 2008 R2 Express instance and a geodatabase created with an initial size of 10 GB.