Debug Symbols for SQL 2008 SP3 and SQL 2008 R2 SP2 missing from Public symbol server   1 comment


For those who love debugging and wondered (like me) why the debugger fails to load symbol for a dump generated  by SQL 2008 SP3 and/or SQL 2008 R2 SP2, let me tell you it’s not only you. Its just that the symbols for the said builds do not seem to be available on the public symbol server as of this writing.

I just filed a bug for SQL 2008 R2 SP2 after responding to a forum question. Please vote it if you are facing this issue and want Microsoft to consider this as important and resolve quickly. There is already a bug filed for this issue for build SQL 2008 SP3

If you are yet to figure out this issue, let me paste the error you may get when trying to load symbols for a dump file taken from the following builds of SQL Server:

  • SQL Server 2008 SP3  build version 10.0.5500
  • SQL Server 2008 R2 SP2 10.50.4000

Windbg Results

0:011> lmvm sqlservr
start    end        module name
00680000 03031000   sqlservr   (deferred)            
    Image path: D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe
    Image name: sqlservr.exe
    Timestamp:        Thu Jun 28 13:49:18 2012 (4FECC34E)
    CheckSum:         0292FBBE
    ImageSize:        029B1000
    File version:     2009.100.4000.0
    Product version:  10.50.4000.0
    File flags:       0 (Mask 3F)
    File OS:          40000 NT Base
    File type:        1.0 App
    File date:        00000000.00000000
    Translations:     0409.04b0
    CompanyName:      Microsoft Corporation
    ProductName:      Microsoft SQL Server
    InternalName:     SQLSERVR
    OriginalFilename: SQLSERVR.EXE
    ProductVersion:   10.50.4000.0
    FileVersion:      2009.0100.4000.00 ((KJ_PCU_Main).120628-0827 )
    FileDescription:  SQL Server Windows NT
    LegalCopyright:   Microsoft Corp. All rights reserved.
    LegalTrademarks:  Microsoft SQL Server is a registered trademark of Microsoft Corporation.
    Comments:         SQL

0:011> .reload /f sqlservr.exe
*** ERROR: Symbol file could not be found.  Defaulted to export symbols for sqlservr.exe -

SYMCHK Results

C:\Debuggers>symchk /v D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe /s http://msdl.microsoft.com/download/symbols
[SYMCHK] Searching for symbols to D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe in path http://msdl.microsoft.com/download/symbolsDBGHELP: Symbol Search Path: http://msdl.microsoft.com/download/symbols
[SYMCHK] Using search path "http://msdl.microsoft.com/download/symbols"
DBGHELP: No header for D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe.  Searching for image on disk
DBGHELP: D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe - OK
SYMSRV:  C:\Debuggers\sym\sqlservr.pdb\643039FABB22452FB3ED83E2C8F689072\sqlservr.pdb not found
SYMSRV:  http://msdl.microsoft.com/download/symbols/sqlservr.pdb/643039FABB22452FB3ED83E2C8F689072/sqlservr.pdb not found
DBGHELP: sqlservr - no symbols loaded
[SYMCHK] MODULE64 Info ----------------------
[SYMCHK] Struct size: 1680 bytes
[SYMCHK] Base: 0x01000000
[SYMCHK] Image size: 43716608 bytes
[SYMCHK] Date: 0x4fecc34e
[SYMCHK] Checksum: 0x0292fbbe
[SYMCHK] NumSyms: 0
[SYMCHK] SymType: SymNone
[SYMCHK] ModName: sqlservr
[SYMCHK] ImageName: D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe
[SYMCHK] LoadedImage: D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe
[SYMCHK] PDB: ""
[SYMCHK] CV: RSDS
[SYMCHK] CV DWORD: 0x53445352
[SYMCHK] CV Data:  sqlservr.pdb
[SYMCHK] PDB Sig:  0
[SYMCHK] PDB7 Sig: {00000000-0000-0000-0000-000000000000}
[SYMCHK] Age: 0
[SYMCHK] PDB Matched:  TRUE
[SYMCHK] DBG Matched:  TRUE
[SYMCHK] Line nubmers: FALSE
[SYMCHK] Global syms:  FALSE
[SYMCHK] Type Info:    FALSE
[SYMCHK] ------------------------------------
SymbolCheckVersion  0x00000002
Result              0x00010001
DbgFilename         sqlservr.dbg
DbgTimeDateStamp    0x00000000
DbgSizeOfImage      0x00000000
DbgChecksum         0x00000000
PdbFilename         sqlservr.pdb
PdbSignature        {643039FA-BB22-452F-B3ED-83E2C8F68907}
PdbDbiAge           0x00000002
[SYMCHK] [ 0x00000000 - 0x00010001 ] Checked "D:\Program Files\Microsoft SQL Server\MSSQL10_50.KJ\MSSQL\Binn\sqlservr.exe"

SYMCHK: sqlservr.exe         FAILED  - sqlservr.pdb mismatched or not found

SYMCHK: FAILED files = 1
SYMCHK: PASSED + IGNORED files = 0

One response to “Debug Symbols for SQL 2008 SP3 and SQL 2008 R2 SP2 missing from Public symbol server

Subscribe to comments with RSS.

  1. A quick update – At least SQL 2008 R2 SP2 symbols are available now. I have updated the connect item. Thank you all who voted for this.

    https://connect.microsoft.com/SQLServer/feedback/details/757179/debug-symbols-for-sql-server-2008-r2-sp2-missing-on-public-symbol-server

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: