The Custom Updates Publishing Tool has several methods for restoring data in the Custom Updates Publishing Tool database, but the recommended method is to restore the database using SQL Server 2005 or SQL Server 2005 Express Edition.
Restoring the SQL Server 2005 Database
Restoring the Custom Updates Publishing Tool database from a SQL Server 2005 or SQL Server 2005 Express Edition backup is the most complete method for recovering lost or damaged data. All of the custom software updates and all publishing tool settings are restored using this method.
 Important |
|---|
| The Custom Updates Publishing Tool must be installed prior to restoring the database in SQL Server. The restored data is overwritten if the publishing tool is installed after a restore. |
SQL Server 2005 Express Edition
If you are using SQL Server 2005 Express Edition for the Custom Updates Publishing Tool database, use SQL Server Management Studio Express to restore the database. The following procedure provides the steps to download and install SQL Server Management Studio Express, if necessary, and restore the publishing tool database.
 Note |
|---|
| For more information about SQL Server Management Studio Express, see SQL Server Management Studio Express in the SQL Server 2005 Books Online (http://go.microsoft.com/fwlink/?LinkId=66480). |
-
If SQL Server Management Studio Express is not installed, download the tool at the SQL Se Web site (http://go.microsoft.com/fwlink/?LinkId=66482) and install it on the computer running the Custom Updates Publishing Tool.
-
Start SQL Server Management Studio Express, leave the default values in Server name and Authentication, and then click Connect.
-
Navigate to the mscuptdb database:
<Server Name>\SQLEXPRESS
└ Databases
└ mscuptdb
-
Right-click mscuptdb, click Tasks, click Restore, and then click Database.
-
Select the backup set to restore, and then click OK. The mscuptdb database is restored by default from the mscuptdb.bak file located at %ProgramFiles%\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\.
SQL Server 2005
If you are using SQL Server 2005 for the Custom Updates Publishing Tool database, the following procedure provides the steps using SQL Server Management Studio to restore the publishing tool database.
| Note |
|---|
| For more information about SQL Server Management Studio, see Introducing SQL Server Management Studio in the SQL Server 2005 Books Online (http://go.microsoft.com/fwlink/?LinkId=66481). |
-
Start SQL Server Management Studio, leave the default values in Server name and Authentication, and then click Connect.
-
Navigate to the mscuptdb database:
<Server Name>\SQLEXPRESS
└ Databases
└ mscuptdb
-
Select Database Engine for Server type, select the server name, and then click Connect.
-
Right-click mscuptdb, click Tasks, click Restore, and then click Database.
-
Select the backup set to restore, and then click OK. The mscuptdb database is restored by default from the mscuptdb.bak file located at %ProgramFiles%\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\.
Exporting Custom Updates
The Export Wizard creates a catalog containing all of the custom software updates in the Custom Updates Publishing Tool at the time of the export. The catalog can be imported into a new publishing tool database by using the Import Software Updates Catalog Wizard. All of the custom software updates will be restored, but the publishing tool settings are not restored and will need to be reconfigured.
Publishing Custom Updates
The Publish Wizard creates a catalog containing the custom software updates that have been flagged for publishing. The catalog can be imported into a new Custom Updates Publishing Tool database by using the Import Software Updates Catalog Wizard. The custom software updates that were flagged for publishing are restored, but publishing tool settings are not restored and will need to be reconfigured.