In the event the DataCenter running on Firebird database becomes overloaded (e.g. an increasing number of clients in the network), we recommend moving the DataCenter to an MS SQL server (MSDE / MS SQL 2005 Express Edition, or MS SQL 2000/2005).  

The recomended number of AVG stations connected to each database engine is:

• Firebird - up to 150 clients (general performance reasons)
  
• MSDE / MS SQL 2005 Express Edition (free) - up to 1000 stations (license limitation)
• MS SQL 2000/2005 - 1000+ (limited only by server performance)
  

The migration of your AVG DataCenter from Firebird database to MS SQL database can be done the following way:

1. Install the MS SQL Server
   
   • if you plan to use full MS SQL Server (not Express edition), please install it prior to DataCenter migration
   • in case the SQL server is running on different machine than AVG Admin Server, please make sure that SQL engine accepts connections from other stations. This can be configured in the SQL Server Surface Area Configuration
     
2. Run the AVG Admin Server Deployment Wizard
   
   • select to configure both UpdateProxy and DataCenter role
   • confirm creating of DataCenter database backup
   • select "Create new empty DataCenter database"
   • choose the database type you wish to use
     
   • SQL Server 2005 Express - applicable for MS SQL 2000 Express / 2005 Express Edition
   • Microsoft SQL Server - applicable for MS SQL Server 2000, 2005 and MSDE
   • if you chose MS SQL Server 2005 Express, two options will be presented to you:
   • New SQL Server 2005 Express installation
   • after configuring the database parameters (user name, password, instance name, etc.), you will be provided parameters for the server installation. Please run the installation using these parameters before proceeding further
   • Current SQL Server 2005 Express instance configuration
   • in the next dialogue, please fill in the connection details
     
   • if you chose Microsoft SQL Server, please fill in the connection details
   • select "Import data into the database from folder", and provide path to the previously created backup
3. Configure the UpdateProxy role
   • in case it was already configured, you do not need to change anything
   • these steps are only necessary to write these information into the new database and keep UpdateProxy active
4. Finish the AVG Admin Server Deployment Wizard
   
   • click "Deploy" to create the new AVG DataCenter database in the MS SQL server

Now, please run the AVG Admin Console to verify the AVG Admin Server is configured and running correctly.

AVG Remote Administration supports several database systems. Their specifics and installation's recommendations can be found below:

To ensure proper function of AVG Remote Administration using MySQL database for DataCenter role, make sure that size of sent packets does not exceed the value of MySQL global variable max_allowed_packet (which is 1048576 bytes, i.e. 1MB by default). Otherwise, there might be problems communicating with the server and error "Synchronization of configuration failed (Admin server returner error)" will appear in AVG Remote Administration.

You can use one of these two solutions:

Set the value for current run only
This will apply the setting until restart of the server occurs. Then the default value or value from my.ini will be used again. Note that you need to be logged as administrator with MySQL root privileges.

• On the MySQL server run this command
  set global max_allowed_packet = 10485760

Change Settings in the my.ini file
This will save the settings permanently, but requires restart of the MySQL server.

• Edit the my.ini file on the MySQL server
• Under the section [mysqld] change max_allowed_packet to read the following:
  max_allowed_packet = 10485760
• restart the mysqld daemon

In case you need to create a backup or export of your AVG DataCenter, there are two possible ways how to do that:

1. Automatically
AVG Remote Administration performs regular backups automatically. They are created every 48 hours and stored for 30 days on your hard drive by default.

In case that you wish to alter these values, please edit the AVG Admin Server configuration file (avgadmsv.ini). This file is stored in the program folder of AVG Remote Administration in:
C:\Program Files\AVG\AVG9 Admin\Server

The last two values in avgadmsv.ini file refer to the regular database backup:

• DatabaseBackupPeriod=48
  • How often in hours should AVG Admin Server backup database.
  • Default value is 48 hours.
  • In case you wish to disable regular backups, please set to 0.
• MaxDatabaseBackupAge=30
  • How long should Admin Server store regular database backup in days.
  • Default vaule is 30 days.
  • In case that you wish to disable deleting of backups, please set to 0.

Automatic backups are stored in the following location:
C:\Documents and Settings\All Users\Application Data\avg9\Admin Server Data\AutoDatabaseBackup
Each backup is created into a separate folder which corresponds with the creation date and time.

When database backup is finished, message in AVG Admin Server Monitor is displayed.

2. Manually
In case that you need to create an unscheduled export of your AVG DataCenter, you can create it as follows:

• Run AVG Admin Console.
• Choose the Database export option from the DataCenter menu.
• This database export will be store into following folder:
  C:\Documents and Settings\All Users\Application Data\avg9\Admin Server Data\DatabaseBackup

In case you need to import a database from backup please proceed as follows:

• If you are about to install the AVG Remote Administration on a new server please refer to FAQ 2178.
• If you need to import your database on the current server please follow these steps:
  • Run AVG Admin Server Deployment Wizard.
  • Untick the Perform DataCenter database backup to folder option on the Database backup screen.
  • Choose the Create new empty DataCenter database option.
  • Choose the appropriate database type.
  • Tick in the Import data into the database from folder option and using the "..." button please navigate to the folder with stored database exports.
  • Finish the wizard.

This failure of the Oracle 10g database on 64-bit OS when deploying AVG DataCenter is caused by a bug in Oracle. Let us inform you, that the Oracle version 10.2.0.1.0 does not support Program Files (x86) directory on 64bit operating systems.

In order to succesfully deploy the AVG database on the Oracle system, please apply one of the following solutions:

Solution 1:
Install AVG Remote Administration into another directory than Program Files (x86). For example:
C:\AVGAdmin

After this step, creation of a new database will finish without any problems.

Solution 2:
Install the Oracle patch part 4. This patch will update the database version from 10.2.0.1.0 to 10.2.0.3.0.

All patches are available on the Oracle's website at:
http://www.oracle.com/technology/support/patches.htm
Note: We would like to inform you, that in order to download this patch, it is necessary to own a valid Support Identifier (CSI).

In case of any further issues deploying a new database on Oracle system, please do not hesitate to contact our AVG Customer Services team.