Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Back Up a Database

Create a backup of your database in case of a system failure. You can use the UDDI Services command-line backup tool (backup.exe) or SQL Server to back up the database. For information about backing up a database using SQL Server, see SQL Server Help.

Cc771653.Important(en-us,BTS.70).gifImportant
Before you back up any data, we highly recommend that you stop all UDDI Services Web servers that are connected to the database instance for which you are creating a backup. For more information, see Start or Stop a Web Server.

Membership in Administrators, or equivalent, is the minimum required to complete this procedure.

To back up a UDDI Services Database using a command line

  1. On the computer that hosts the UDDI Services Database that you want to back up, open a command prompt with Administrator credentials. To open a command prompt, click Start, right-click Command Prompt, and then click Run as administrator.

  2. Type the following command, and then press ENTER:

    CD UDDI_Services_Installation_Directory\bin
    

    The default UDDI Services installation directory is:

    
    										%Program Files%\Microsoft UDDI Services\
    
  3. Type the following command, and then press ENTER:

    backup.exe [/<backup:file>] [Database_Instance_Name]
    

    Parameter Description

    backup.exe

    Backs up or restores the UDDI Services Database.

    Cc771653.note(en-us,BTS.70).gifNote
    backup.exe cannot restore the latest version of the backup data from a data file that contains multiple backups.

    /<backup:file>

    The name of the SQL Server database instance where the UDDI Services Database is installed. If no database is specified, the tool reads the configured database instance from the Windows registry.

    For example, to back up a UDDI Services Database that is hosted in a database instance named UDDI, type the following command, and then press ENTER:

    backup.exe UDDI
    

    A backup of your data is placed in:

    
    										UDDI_Services_Installation_Directory\data\UDDI.database. yyyyMMddHHmm.bak. 
    
  4. Copy this file to another location, or back it up for safekeeping.

Membership in Administrators, or equivalent, is the minimum required to complete this procedure.

To restore a UDDI Services Database using a command line

  1. On the computer that hosts the UDDI Services Database that you want to restore, open a command prompt with administrator privilege. To open a command prompt, click Start, right-click Command Prompt, and then click Run as administrator.

  2. Type the following command, and then press ENTER:

    CD <UDDI_Services_Installation_Directory>\bin
    

    The default UDDI Services installation directory is:

    
    										%Program Files%\Microsoft UDDI Services\
    
  3. Type the following command, and then press ENTER:

    backup.exe /restore[:<file>] [<Database_Instance_Name>]
    

    Parameter Description

    backup.exe

    Backs up and restores the UDDI Services Database.

    Cc771653.note(en-us,BTS.70).gifNote
    backup.exe cannot restore the latest version of the backup data from a data file that contains multiple backups.

    /restore[:<file>]

    Restores the UDDI Services Database from a backup file. If a backup file is not specified, by default the tool finds the UDDI_Services_Installation_Directory \data\uddi.database.timestamp.bak that has the latest time stamp.

    <Database_Instance_Name>

    The name of the SQL Server database instance where the UDDI Services Database is installed. If no database is specified, the tool reads the configured database instance from the Windows registry.

    For example, to restore a UDDI Services Database to a database instance named UDDI, type the following command, and then press ENTER:

    Backup.exe /restore UDDI
    

Additional considerations

  • Backups that you create by using this tool contain physical paths and file names for Universal Description, Discovery, and Integration (UDDI) data files that are specific to the current installation. For this reason, you cannot use this tool to migrate data from one UDDI Services installation to another.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.