When you try to open a report you receive the following error message, but you know the SQL Service is running and the 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 © 2017
|
|