System Center Updates Publisher has several methods for restoring data in the Updates Publisher database, but the recommended method is to restore the database by using SQL Server 2005 or SQL Server 2005 Express Edition. All of the software updates and all publishing tool settings are restored by using this method.

Important
Updates Publisher must be installed prior to restoring the database in SQL Server. The restored data is overwritten if Updates Publisher is installed after a restore.

When SQL Server 2005 Express Edition is used for the Updates Publisher database, use SQL Server Management Studio Express to restore the database. 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).

When SQL Server 2005 is used for the Updates Publisher database, use SQL Server Management Studio to restore the Updates Publisher database. 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).

Use the procedures in this topic to download and install SQL Server Management Studio Express, if necessary, and restore the publishing tool database, or to use SQL Server Management Studio to restore the publishing tool database.

To download, install, and use SQL Server Management Studio Express to restore the Updates Publisher database

  1. If SQL Server Management Studio Express is not installed, download the tool at SQL Server 2005 Express Edition download (http://go.microsoft.com/fwlink/?LinkId=66482) and install it on the computer running Updates Publisher.

  2. Start SQL Server Management Studio Express, leave the default values in Server name and Authentication, and then click Connect.

  3. Navigate to the mscuptdb database:

    <Server Name>\SQLEXPRESS

      └ Databases

        └ mscuptdb

  4. Right-click mscuptdb, click Tasks, click Restore, and then click Database.

  5. 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\.

To use SQL Server Management Studio to restore the Updates Publisher database

  1. Start SQL Server Management Studio, leave the default values in Server name and Authentication, and then click Connect.

  2. Navigate to the mscuptdb database:

    <Server Name>\SQLEXPRESS

      └ Databases

        └ mscuptdb

  3. Select Database Engine for Server type, select the server name, and then click Connect.

  4. Right-click mscuptdb, click Tasks, click Restore, and then click Database.

  5. 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\.

See Also