UltraBac Database

UltraBac has the ability to add backup indexes, sets, groups, and logs to several types of database:

 

Microsoft SQL Server (2008, 2005, and 2000)

Microsoft SQL Server 2008 Express

Microsoft SQL Server 2005 Express

MySQL 5.1

 

NOTE:  For information on configuring the SQL server prior to setting up the UltraBac Database, please see the UltraBac Knowledge Base:

 

See UBQ000253:  Configuring SQL for use with the UltraBac Database

Setting up the UltraBac Database

To set up the UltraBac Database:

 

  1. From the Start Menu, click "All Programs"/"UltraBac Software"/"UltraBac Database Setup."

    udb001.gif
    Fig. 1 - UltraBac Database Setup.
     

  2. Select "Setup a new UltraBac Database Server," and click "Select."

  3. Select the SQL platform to host the UltraBac Database.

    udb002.gif
    Fig. 2 - Selecting the database platform.
     

  4. Type or browse to the name of the SQL host.

  5. Enter the Instance name, if one exists.  If not, leave the "Instance Name" empty.

  6. Enter the name of a native SQL account (i.e. the "SA" account) that UltraBac will use to create the database.

  7. Enter the corresponding password.

    udb003.gif
    Fig. 3 - Specifying the Microsoft SQL server.
     

  8. Click "Test Connection" to ensure that the specified account has permission to create the UltraBac database.

  9. Click Select

  10. Enter the account UltraBac will use for connection to the database and click "OK." If the specified account does not exist, UltraBac will create it.

    udb004.gif
    Fig. 4 - Entering the database administration account.
     

  11. Enter the path where the UltraBac databases will be stored.  15 GB free space is required for installation.

    udb005.gif
    Fig. 5 - Setting the database location.
     

  12. Click "Select" to create the UltraBac databases.