Microsoft SQL Server 2008 Express Edition is a free, lightweight version of Microsoft SQL Server and is packaged with CA ARCserve Backup. Review the following information if you are considering using Microsoft SQL Server 2008 Express Edition to support the CA ARCserve Backup database:
- Ensure that the ARCserve system account has administrative privileges on Microsoft SQL Server 2008 Express Edition databases.
- Microsoft SQL Server 2008 Express Edition does not support remote operations. You must install the ARCserve database locally to your CA ARCserve Backup server.
- Microsoft does not recommend running Microsoft SQL Server 2008 Express Edition as a Local System account, a Local Service account, or Network Service account on Windows Server 2003 and Windows Server 2008 systems that function as domain controllers. When you install CA ARCserve Backup on a system that functions as a domain controller, Setup configures the CA ARCserve Backup database (ARCSERVE_DB) to communicate using a Local System account, and all other services to communicate using a Network Service account. To ensure that the CA ARCserve Backup database can communicate on Windows Server 2003 and Windows Server 2008 systems that function as a domain controller, you must change the Microsoft SQL Server 2008 Express Edition account to a Windows domain user account after you install CA ARCserve Backup.
Note: For information about how to change the Microsoft SQL Server 2008 Express Edition account to a Windows domain user account, see the Microsoft SQL Server documentation.
- Microsoft SQL Server 2008 Express Edition is not supported on IA-64 (Intel Itanium) operating systems.
- To function properly, Microsoft SQL Server 2008 Express Edition requires that .NET Framework 3.5 SP1 be installed on your system. Microsoft .NET Framework 3.5 SP1 is packaged with CA ARCserve Backup and is provided for you on the CA ARCserve Backup installation media.
- If you determine that Microsoft SQL Server 2008 Express Edition does not meet the needs of your CA ARCserve Backup environment, you can use the Server Configuration Wizard to convert the CA ARCserve Backup database to Microsoft SQL Server and then migrate your existing data to the new database after the conversion is complete. You can convert the database at any time after you install or upgrade CA ARCserve Backup.
Note: For information about upgrading from Microsoft SQL Server 2008 Express Edition to Microsoft SQL Server, see the Administration Guide.
- CA ARCserve Backup does not support migrating data from a Microsoft SQL Server database to a Microsoft SQL Server 2008 Express database. Therefore, if you are currently running Microsoft SQL Server in your environment, you must deploy Microsoft SQL Server for the CA ARCserve Backup database.
- For Global Dashboard, you cannot configure the CA ARCserve Backup database for the Central Primary Server with Microsoft SQL Server Express installed. Microsoft SQL Server 2005, or later, must be installed on the Central Primary Server.
- You can download and install the latest updates, security patches, and service packs that apply to the version of Microsoft SQL Server 2008 Express Edition that is running in your environment. The Compatibility Matrix on the CA support web site can help you determine the applicable updates for your implementation.
Important! You should always check the Compatibility Matrix on the CA support website before you apply Microsoft SQL Server 2008 Express Edition service packs to your CA ARCserve Backup implementation. After determining the compatible service packs, you should apply the updates and security patches based on the recommendations of Microsoft.
- Consider the following upgrade scenarios:
- You are using Microsoft SQL Server 2005 Express Edition to host the CA ARCserve Backup database. The name of the CA ARCserve Backup database instance is ARCSERVE_DB (default). This scenario also includes situations where a previous release of CA ARCserve Backup may not be installed on the target system, however, Microsoft SQL Server 2005 Express Edition is installed on the target system and you are using an instance named ARCSERVE_DB for other applications.
- You are using Microsoft SQL Server 2005 Express Edition to host the CA ARCserve Backup database. The name of the CA ARCserve Backup database instance is not ARCSERVE_DB.
When you upgrade to this release, Setup searches for the default CA ARCserve Backup database instance. If Setup detects an instance named ARCSERVE_DB, Setup upgrades the instance to Microsoft SQL Server 2008 Express Edition, and CA ARCserve Backup continues using the instance, and data, from the previous release. However, if Setup cannot detect an instance named ARCSERVE_DB, Setup creates a new instance called ARCSERVE_DB. If Setup creates a new database instance, the information from the previous CA ARCserve Backup release is not retained in the new instance.