Microsoft KB Archive/833378

= You cannot use the UDDI Services database restore command-line tool to restore the UDDI Services database to an instance of SQL Server on a SQL Server failover cluster =

PSS ID Number: 833378

Article Last Modified on 1/16/2004

-

The information in this article applies to:


 * Microsoft Windows Server 2003, Datacenter Edition
 * Microsoft Windows Server 2003, Enterprise Edition
 * Microsoft Windows Server 2003, Standard Edition
 * Microsoft Windows Server 2003, Web Edition
 * Microsoft SQL Server 2000 (all editions)

-





SYMPTOMS
You cannot use the Universal Description, Discovery, and Integration (UDDI) Services database restore command-line tool (uddi.database.restore.cmd) to restore the UDDI Services database to an instance of Microsoft SQL Server on a SQL Server failover cluster.



WORKAROUND
To work around this problem, use one of the following methods:  Use the Restore database option in SQL Server Enterprise Manager to restore the UDDI Services database.  From the command prompt, run the following command to restore the UDDI Services database: osql -S  -E -Q &quot;RESTORE DATABASE > with the appropriate name of the instance of SQL Server. Replace < > with the appropriate path and with the appropriate name of the database backup file that is to be restored. Replace < > with the UDDI Services database name that is to be restored.

The switch options for the osql command are case sensitive. 

