Open topic with navigation

Double-Take Reporting Service

The Double-Take Reporting Service is a centralized reporting and analysis tool that allows you to create detailed, custom reports of all Double-Take servers in your environment. It can be used to show the overall effectiveness of Double-Take protection over time and to analyze trends in a data protection scheme. After you install and configure Double-Take Reporting Service, it monitors and collects data from the Double-Take servers you specify. It sends the collected data to a SQL database that you create and maintain.

To use Double-Take Reporting Service, your environment must meet the following requirements.

• The reporting service must be installed on a Windows operating system.
• The reporting service cannot be installed on a Double-Take source or target server. The reporting service can be run with a Double-Take client only installation.
• You must have an existing server running SQL Server 2005 or later.
• The reporting service can be run on the SQL server or a different server.
• A new SQL database needs to be created, however no tables should be created because Double-Take Reporting Service will automatically create the tables it needs.
• The newly created SQL database needs established security credentials. The database user role membership must initially include db_owner and public to allow Double-Take Reporting Service to create the tables it needs. Once the tables have been created (during the database configuration in step 4 below), the database user role membership can be changed, if desired, to db_datareader, db_datawriter, and public.
• Your SQL server authentication must be set to SQL Server and Windows Authentication mode.
• Your SQL server must have TCP/IP enabled and all IP addresses on the SQL server must be using the same port. Additionally, the SQL server must be set to listen on all IP addresses. See your SQL documentation for details on these settings.
• If you are using a firewall on your SQL server, make sure it does not block SQL or Double-Take Reporting Service traffic.

If you want to use Double-Take Reporting Service, you will need to complete the following steps, in order.

1. Create your SQL database according to the requirements above. See your SQL documentation for detailed instructions on configuring SQL server and databases.
2. Install Double-Take Reporting Service. See Installing Double-Take Reporting Service.
3. Add the server where you installed Double-Take Reporting Service to your console. See Adding servers.
4. Configure the Double-Take Reporting Service server. See Configuring the Double-Take Reporting Service server. This is the step where your database user role membership must initially include db_owner and public.

Once your configuration is complete, Double-Take data will be collected and you can use standard SQL queries and tools to create your own customized reports. See your SQL documentation for detailed instructions on creating queries and reports. For a complete list of the data stored in the Double-Take Reporting Service tables, see Double-Take Reporting Service tables.