CA: ARCserve Troubleshooting SQL Server issues

Below you will find a summary of issues that may occur with links to solutions.

• Best Practices for protecting SQL Server data bases.
• Configuring Database Maintenance Operations in ARCserve
  • See Knowledge Base Article on Database Maintenance Operations.
• Using SQL Server 2008 for ARCserve r12.5 backup database
  • See below for installation information
  • See Knowledge Base Article on How to install and use SQL Express 2008 for use with ARCserve 12.5
• SQL Server for ARCserve Database did not install successfully.
  • See Knowledge Base Article on installing SQL Server Express.
  • It is recommended that you download the latest version of SQL Server 2008 R2 Express and manually install it.
    • Maximum database size is now 10 GB instead of 4GB with SQL Server 2005
• Error Message: "Consistency validation for SQL Server registry keys" during Installation of SQL Server
  • This is usually resolved by running as administrator (permissions issue)
  • See Knowledge Base Article on Installation of SQL Express 2008 fail with the error.
• Restoring a backup to a different location. This may occur when using a backup for a test or development machine.
  • See Knowledge Base Article on How to restore SQL transaction log to alternate locations.
• Re-enabling a login that is locked out (Audit Failure - Event Id 529)
  • ARCserver tracks failed login request and disables accounts (see this post for an explaination of how this may be done)
  • Execute Select * from [asdb].[dbo].[asuserdb] where object like 'srv-backup%' and delete the entries associated with this login
  • See Knowledge Base Article on Audit Failure "Event id 529" locking the Windows logon account.

• Speeding up backup by using more than one CPU (default setting)
  • See Knowledge Base Article on How to configure ARCserve Backup to use multiple CPUs (Processor Affinity)...
• Out of disk space: Moving the ARCserver database to a different drive
  • See Knowledge Base Article on How to move the ARCserve SQL database to another drive.
• Problems doing an upgrade of SQL Server Express from r12.5 to r15
  • Manually install SQL Server 2008 R2 (see above)
  • Then upgrade ArcServe
  • See Knowledge Base Article on Unable to Upgrade SQL Express 2005 to SQL Express 2008 While Upgrading
• Adjust memory for SQL Server Express
  • The maximum memory for SQL Server Express 2005 is 1 GB
  • The maximum memory for SQL Server Express 2008 R2 is 1 GB
  • See Knowledge Base Article on Set Maximum memory usage limit for Microsoft SQL Express.
  • You may also wish to set minimum memory to be 1GB, see this post.
• Cannot open a connection to SQL Server.
  • Ensure that TCP/IP and Names Pipes are enabled.
  • See this post to see how this is done.
  • See Knowledge Base Article on [Microsoft][Sql Native Client] Named Pipes Provide: Could not open a connection to SQL SERVER [2].