Upgrade MS SQL 2005 Express SP2 or higher to full MS SQL Server 2005 SP3

To upgrade a SQL Express 2005 SP2 installation to a full version of SQL 2005, using a disc which does not include a service pack, SP2 or higher, you can use one of the following methods.

Note: We recommend that before you perform either of these methods, you back up the Autodesk data management server console.

Method 1

1. Open a command prompt, and navigate to the directory where the full version of SQL setup is located.
2. Enter SETUP.EXE SKUUPGRADE=1" (case sensitive).
3. Start the upgrade, and select the AutodeskVault instance.
4. After the upgrade is complete, apply SQL Service Pack 3.

Method 2

1. Create a full backup of your vault using the Autodesk data management server Console.
   Note: In later steps, you delete all of your vault databases. Before you proceed, validate that you can restore this backup on a test server. If your test restore fails, do not continue. Correct any problems you have with the backup before you continue these steps.
2. After the test restore is successful, open the Autodesk data management server Console and delete all vaults and libraries listed. Then, on the Tools menu, select Detach Master Vault.
3. Make sure all users are logged out of the vault.
4. Completely uninstall SQL 2005 Express, including the following applications, in this order:
   • Microsoft SQL Server 2005
     Note: If you have more than one instance of SQL Express installed, uninstall only the AutodeskVault instance, and DO NOT uninstall any other part of SQL after this step is complete.
   • MS SQL Server Native Client.
   • MS SQL Server VSS Writer.
   • MS SQL Server 2005 Backward Compatibility.
   • MS SQL Server Setup Support Files.
5. Delete the SQL Express folders from Program Files (including data files). If your Vault databases are located on a different drive, delete the files in this location as well. **Do this ONLY if you are not using any other SQL Express instances.
6. Install the full version of SQL 2005 with an AUTODESKVAULT instance as in the Install MS SQL Server Prior to Installing Autodesk data management server section.
7. Install Microsoft SQL 2005 SP3.
8. Restore the backup that you created in step 1, using Autodesk data management server Console.

If you have difficulty removing the MS SQL Express instance, refer to Microsoft Knowledgebase article 909967 to help manually remove this instance.

Note: For optimum performance, create a SQL Maintenance Plan after you perform this upgrade. Follow the steps in the Creating a SQL Maintenance Plan section.