Export (0) Print
Expand All

Back Up a Database

Applies To: Windows Server 2008

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.

ImportantImportant
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.

Backing up a UDDI Services Database

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.

  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.

    noteNote
    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.

Restoring a UDDI Services Database

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.

  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.

    noteNote
    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.

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