[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11904
  • Last Modified:

SQL error messages. MSSQL$BKUPEXEC -- Event ID's 2803 and 17137

I am getting these informational event logs under the application events in windows 2003 server.  Can someone shed some light here for me.  These messages keep poping up every minute or 2 in the event logs.  Are these two error messages related and how do I fix them?

Error 2803 -- SQL Server has encountered 7 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

Error 17137 -- Starting up database 'BE_DLO'.
0
ctbtech
Asked:
ctbtech
  • 2
  • 2
1 Solution
 
David ToddSenior DBACommented:
Hi,

Given that this database is to support Backup Exec from Symantec, I'd firstly be inclined to put a support call through to them. If nothing else you want to find out how this database sever instance is supposed to be configured.

It looks like BE_DLO database might be on autoclose. from memory you can check by running this query:
execute sp_dboption @dbname = 'BE_DLO', @optname = 'autoclose'

Look up sp_dboption in Books On Line (BOL)

HTH
  David
0
 
ctbtechAuthor Commented:
I found the solution myself.  Thanks for the help though.
0
 
David ToddSenior DBACommented:
Hi,

And the solution is?

If you ahve answered this yourself, you can request in Community Support for a moderator to PAQ (Previously Asked Question) with refund.

HTH
  David
0
 
ctbtechAuthor Commented:
Had somthing to do with a backup job not connecting to a network drive.  Turned out not to be that important.

I didn't know about the PAQ.. Thanks

I'll do that next time... meanwhile here goes points.
0
 
integrityts7723Commented:
I received several instances of this error just before Backup Exec stops all services.  The services can be manually restarted and everything continues working as though nothing happened, but I don't see a reason why it stopped in the first place.  It was 7 hours after the last successful backup job ran and there was not another one scheduled for 13 hours later.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now