I'm getting the following event logged periodically in App log for one of our servers running BE10. BE10 is installed on a W2000 SP4 server, and is also backing up 3 other W2000 SP4 servers (one has SQL agent) Anyone know why this occurs or how to get rid of it?: Event Type:Information Event Source:MSSQL$BKUPEXEC Event Category2) Event ID:17055 Date:3/1/2006 Time:10:08:10 AM User:N/A Computer: Description: 17052 : This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
The issue appears to be related to MSDE. Please ensure that user connections is set to "0". Perform the following steps: ---Go to the Command Prompt. ---Change directories to C:\Program Files\Microsoft SQL Server\80\Tools\Bin Folder on the media server. ---Run the command: osql -S%computername%\bkupexec -E -Q sp_configure
Check that the "user connections" is set to 0, which is unlimited.
If above does not resolve the issue, please reapply the MSDE2000 SP3a. You may download the same from the Microsoft website.
NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to the answered questions pool.