Share via


Back Up the Existing Evaluation User Database (Optional)

Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.

As a best practice, back up the existing evaluation version of the User database on an Enterprise pool or Standard Edition Server before upgrading the pool and server.

To back up the RTC user database, use the following procedure and one of the following tools:

  • For the RTC database on a Standard Edition server, SQL Server 2005 Express Edition.

  • For the RTC database on a back-end server in an Enterprise pool, SQL Server 2005.

Note

The following backup procedure assumes that you are using Windows Authentication to access SQL Server 2005.

To back up the user database

  1. Log on to the evaluation version of your Office Communications Server 2007 Standard Edition Server or the Enterprise pool Back-End Database as a member of the Administrators group on the local computer or a group with equivalent user rights.

Important

  The service account you use to back up the SQL database must be the same one that you will use to restore the SQL database.

  1. On the server, do one of the following:

    • To open SQL Server Management Studio Express, click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio Express.

    • To open SQL Server Management Studio, click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the console tree, expand the server group, expand the server node, and then expand Databases.

  3. Right-click RTC, point to Tasks, and then click Backup.

  4. In the Back Up Database dialog box, on the General tab, under Source, do the following:

    • In the Database box, click RTC.

    • In Backup type, click Full.

    Note

    Office Communications Server 2007 supports only full backups of SQL databases.

  5. Under Backup Component, verify that Database is selected.

  6. Under Backup Set, do the following:

    • In Name, type a name for the backup set.

    • Optionally, in Description, type a description of the backup set.

    • Under Backup set will expire, specify when the backup set expires.

  7. Under Destination, click Disk or Tape, and then do one of the following:

    • If a destination is displayed, verify that it is correct.

    • If the wrong destination is displayed, click Remove.

    • If the correct destination is not displayed, click Add to specify the destination.

  8. If a previous backup set exists that you want to append or overwrite, in the Back Up Database dialog box, on the Options tab, verify that Back up to the existing media set is selected, and then do one of the following:

    • To append the backup to any existing backup set on the backup device, click Append to the existing backup set.

    • To overwrite any existing backup sets on the backup device, click Overwrite all existing backup sets.

  9. To start the backup process, click OK.

  10. To store a back up set in a location other than the one you specified for the backup destination (such as a secure, remote location that can be accessed if you need to restore the data), after the backup completes, copy the backup set from the backup location to the other location.

  11. Verify that the backup set is accessible for restoration purposes, including by standby servers if your organization is deploying separate, secondary sites for recovery in the event of a site failure.