Recover when the Populate process leaves a product in a mixed state

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.