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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 EVENT ID 18056
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dev2014
Starting Member

2 Posts

Posted - 10/06/2014 :  22:22:07  Show Profile  Reply with Quote
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

United Kingdom
84 Posts

Posted - 10/07/2014 :  06:11:23  Show Profile  Reply with Quote
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

Edited by - Shanky on 10/07/2014 06:12:25
Go to Top of Page

dev2014
Starting Member

2 Posts

Posted - 10/07/2014 :  21:23:37  Show Profile  Reply with Quote
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
Go to Top of Page

Shanky
Yak Posting Veteran

United Kingdom
84 Posts

Posted - 10/08/2014 :  09:23:38  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000