|
|
|
When you try to open a report you receive the following error message, but you know the SQL Service is running and the CA ARCserve Backup database (ASDB) is online:
"Unable to connect to ASDB Database. Please make sure that SQL SERVICE is running and ASDB database is ONLINE"
Reason:
Microsoft SQL server is reusing the cached query plan, but the query plan is poor.
Action:
On the central database machine, open SQL Server Management Studio and run the following command:
dbcc freeproccache
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |