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].