EVENT ID 18056 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

EVENT ID 18056

Author

Topic

dev2014
Starting Member

2 Posts

Posted - 2014-10-06 : 22:22:07

Hi all,
Would like to know the reason for below message while taking backup in sql server 2008 SP2. There is sufficinet disk space on the server. Full backup runing at midnight, differential backup running every 4 hours ans transaction back every hour. This message is generated though backup was successful and happens daily. Is it something to do with SP update?

GGN - GGSQLP01 - SEV:2 - Server-DBA - Alert SQLerr File SYSTEM_LOG\application MatchPattern Computer: .* Source: MSSQL$.* Type: [Ee].* Event-ID: .* User: .* Category: .* Description: .* Line Computer: GGSQLP01.ads.horizonpower.com.au Source: MSSQL$INFRAST Type: Error Event-ID: 18056 User: - Category: (2) Description: The description for Event ID ( 18056 ) in Source ( MSSQL$INFRAST ) cannot be found. It contains the following insertion string(s):5729 Date: 2014-10-06 Time: 20:10:22.

Cheers,
Dev

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-10-07 : 06:11:23

This message is unclear can you see in SQL Server errorlog if you can find more details related to error any relevant message in event viewer. Its very hard to understand what this error is pointing to

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx

dev2014
Starting Member

2 Posts

Posted - 2014-10-07 : 21:23:37

Thanks Shanky.
Following errors are found in error log.
2014-10-06 20:10:22.940 spid57 Error: 18056, Severity: 20, State: 29.
2014-10-06 20:10:22.940 spid57 The client was unable to reuse a session with SPID 57, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this er
2014-10-06 23:46:02.060 spid66 Error: 18056, Severity: 20, State: 29.
2014-10-06 23:46:02.060 spid66 The client was unable to reuse a session with SPID 66, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this er

Thanks, Dev

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-10-08 : 09:23:38

What is version and edition of database make sure it is patched to latest SP. Microsoft has released very helpful blog to track such messages actually this is more of a symptom to some issue you can use http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx to find out cause. You should also read http://blogs.msdn.com/b/sqlsakthi/archive/2011/07/06/error-18056-state-29-the-client-was-unable-to-reuse-a-session-the-failure-id-is-29-after-upgrading-sql-2000-to-sql-2008-sp2.aspx

Hope this helps

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources