cancel
Showing results for 
Search instead for 
Did you mean: 

Event ID 17055 in App log

Aron_Shevis
Level 4
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 Category:(2)
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.

Data:
0000: 9c 42 00 00 0a 00 00 00 œB......
0008: 16 00 00 00 47 00 45 00 ....G.E.
0010: 54 00 54 00 48 00 45 00 T.T.H.E.
0018: 59 00 41 00 4e 00 4b 00 Y.A.N.K.
0020: 45 00 45 00 5c 00 42 00 E.E.\.B.
0028: 4b 00 55 00 50 00 45 00 K.U.P.E.
0030: 58 00 45 00 43 00 00 00 X.E.C...
0038: 07 00 00 00 6d 00 61 00 ....m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
1 REPLY 1

padmaja_rajopad
Level 6
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.