Work with libraries stored on SQL Express server

When you store libraries on a server with Microsoft SQL Express, the limit for size of each library is 4 GB. Operations that cause exceeding the library limit cannot be completed.

Tip: To avoid problems with the library size limit, upgrade the server to a full version of Microsoft SQL.

Split a large user library to prevent exceeding the size limit

Move a portion of content to a new library to reduce the library size.

1. Create a user library on the server.
   • Run the server console.
   • In the server console window, expand the root, and right-click the Libraries entry.
   • Click Create Library on the menu.
   • Enter the library name in the Create library dialog box, and click OK. A new user library is created.
2. Add the new library to the Content Center Configuration:
   • In Inventor, click Manage Projects.
   • In the Projects dialog box, click Configure Content Center Libraries.
   • In the Configure Libraries dialog box, select the In Use option for the new library.
   Note: The storage location of Content Center libraries must be Autodesk Vault Server and you must be logged in to the server to complete this step.
3. Move a portion of content to the new library:
   • On the ribbon, click Manage tab Content Center panel Editor to open the Content Center Editor dialog box.
   • From the Library View list, select the large library.
   • Locate and select the content to move.
   • Right-click the selected content, click Move To, and then click the new library to select it as a destination.

     Selected content is removed from the original library and added to the new user library

   Note: A set of families or categories can be moved in one process.
4. Use the Update Tool to update transferred libraries.
5. Use the Transfer Guide to transfer migrated libraries back to the server.
6. Set the Application Options to user the server as the library location. Then set the library configuration in the Configure Libraries dialog box.

Migrate large user libraries stored on SQL Express server

When you migrate a user library by using the Update Tool, the size of the library can grow. As a result, the library can exceed the SQL Express limit. When a library exceeds the limit, the Update Tool stops the migration of this library. The Failures tab on the final Update Tool page lists the problem.

Note: The status of the partly migrated library is unknown and we do not recommend you to use this library.

To resolve the library size problem, do one of the following steps:

• Upgrade the server to full version of Microsoft SQL. Then add the backup version of your library to the server and migrate it.
• Use the following procedure to split the legacy user library to two libraries:

1. Replace the current user library with the original, non-migrated version of the library.
   Tip: If you have no backup version of your library, you can try using the partly migrated library. But remember that the library can include corrupted data.
2. Use the Transfer Guide to transfer the legacy library from the server to the Desktop Content folder.
3. Set the Application Options to use Desktop Content:
   • Click Options to open the Application Options dialog box.
   • On the Content Center tab, select Inventor Desktop Content.
   • Click OK to close the Application Options dialog box.
4. Use the Update Tool to migrate the transferred library.
5. Split the migrated library into two libraries: Create a Desktop Content user library and move a portion of content to this library.
6. Use the Transfer Guide to transfer both libraries to the server.
7. Set the Application Options to use the server as the library storage. On the Content Center tab of the Application Options dialog box, select Autodesk Vault Server.
8. Verify the configuration of Content Center libraries on the server and in the project. If appropriate, add the new user library to the configuration.