English

How To: Recover when the Populate process leaves a product in a mixed state

Summary

The instructions provided describe how to recover when the Populate process leaves a product in a mixed state.

One of the final steps in populating a product instance is checking the MDF database and product MXD back into the Product Library. This procedure involves moving the product MXD back into the Product Library, unmounting the product MDF from the local SQL Server Express, and moving the MDF back into the Product Library.

Occasionally, the product MDF is not checked back into the Product Library. This leaves the product instance in a mixed state which means that the product MXD is checked in but the accompanying product database is not.

Procedure

When the MDF fails to check back into the Product Library, one of two scenarios has occurred.

In scenario one, the MDF is no longer mounted but is stored on the designated directory.

In scenario two, the MDF is still mounted to the SQL Server Express. Verify whether or not the MDF is attached by opening ArcCatalog and expanding the SQL Server Express node.

Senario One - MDF Not Mounted
1. If necessary, install Mircosoft SQL Server 2008 Management Studio Express at Microsoft SQL Server 2008 Management Studio Express Install or install Microsoft SQL Server Management Studio Express (2005) at Microsoft SQL Server Management Studio Express 2005 Install.

2. Open the SQL Server Management Studio application and connect to the local SQL Server. This is usually the default Server name.

3. Expand the Databases node in the Object Explorer tree view.

4. If the Instance database is listed in the tree view but is not a collapsible node, right-click the database and delete it.

5. Close the Microsoft SQL Server Management Studio application.

6. Open Windows Explorer and navigate to the file location of the product instance MDF.

7. Delete the .LDF file with the name of the product instance if it exists.

8. Open ArcCatalog and, if necessary, connect to the local SQL Express Server.

9. Right-click the local SQL Server Express and go to Administration > Attach.

10. Navigate to the file location of the product instance MDF and select it for attachment.

11. Close ArcCatalog once the MDF has been attached.

12. Open ArcMap and expand the Product Library tree view to the product instance in the mixed state.

13. Right-click the product instance and select Manage Files.

14. Right-click the product instance MDF, which should have a green check mark icon. Select Check In.

Senario Two - MDF Mounted to SQL Server Express
1. If the MDF is attached to SQL Express, expand to the product instance node in the Product Library tree view.

2. Right-click the product instance node.

3. Select the Manage Files option.

4. In Manage Files right-click the MDF icon which has a green check symbol on it.

5. Select the Check In option.

6. On the Check In dialog, select the desired the default setting and click OK.