Obtaining symbol files (.PDB) for SQL Server Releases

This section contains PowerShell scripts which automate the download and extraction of .PDB files corresponding to major releases of SQL Server. For running any of these scripts, please note the following:

• You must run them within PowerShell
• You must have Internet access from the machine running the PowerShell script
• You must first replace the placeholder with a path to a directory (for example, N:\sqlsymbols\SQL2016SP1)
• The script will automatically create the folder and a subfolder (called 'extracted') where the downloaded PDB files are stored.
• FYI: The downloaded PDB is actually compressed in CAB format so we expand them at the end to their actual .PDB form.

SQL Server 2016 SP1 GDR (13.0.4202.2)

New-Item -Type Directory -Path <somepath> -ErrorAction SilentlyContinue
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqldk.pdb/e9ce97334e164233802b8a7031584ba82/sqldk.pd_' -OutFile '<somepath>\sqldk.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqlmin.pdb/3367d5d276dc4bf8a46d68df995c1b662/sqlmin.pd_' -OutFile '<somepath>\sqlmin.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqllang.pdb/abacba7963c34eb1ab04f667438efb4f2/sqllang.pd_' -OutFile '<somepath>\sqllang.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqltses.pdb/3f42c5a751ad4a6ab29c70ff9f38c9ce2/sqltses.pd_' -OutFile '<somepath>\sqltses.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqlaccess.pdb/0161de46d8a547eabf2a80654a716b0a2/sqlaccess.pd_' -OutFile '<somepath>\sqlaccess.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/qds.pdb/14ad17149c604fb0960e405182e306f32/qds.pd_' -OutFile '<somepath>\qds.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/hkruntime.pdb/4344be8c97834e62baacf8ec6b8c0e771/hkruntime.pd_' -OutFile '<somepath>\hkruntime.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/hkengine.pdb/c9d9ed9b9d894f40b3506ab11c64fb1d1/hkengine.pd_' -OutFile '<somepath>\hkengine.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/hkcompile.pdb/bfc89ecb13d844f48a0d92e7ee14e6b51/hkcompile.pd_' -OutFile '<somepath>\hkcompile.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/SQLOS.pdb/db48a0e6e08c4b43b37ed8aac8c2fcfc1/SQLOS.pd_' -OutFile '<somepath>\SQLOS.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqlservr.pdb/bf7ec1c675ad41c2b7437785ea88d1602/sqlservr.pd_' -OutFile '<somepath>\sqlservr.cab' # File version 2015.0130.4202.02 ((SQL16_SP1_GDR).161213-0345)
New-Item -Type Directory -Path <somepath>\extracted -ErrorAction SilentlyContinue
expand.exe -r <somepath>\*.cab <somepath>\extracted

SQL Server 2016 SP1 (13.0.4001.0)

New-Item -Type Directory -Path <somepath> -ErrorAction SilentlyContinue
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqldk.pdb/1d3fa75eb35540e287b2e012d69785df2/sqldk.pd_' -OutFile '<somepath>\sqldk.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqlmin.pdb/d38058f49e7c4d62970677e4315f1f1c2/sqlmin.pd_' -OutFile '<somepath>\sqlmin.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqllang.pdb/cb9e5b8e0483423cb122da4ad87534d52/sqllang.pd_' -OutFile '<somepath>\sqllang.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqltses.pdb/13cb00e6ed4d46789fadceb55abddfe92/sqltses.pd_' -OutFile '<somepath>\sqltses.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqlaccess.pdb/c6d08b108b154f8b8431f090dbaab1c92/sqlaccess.pd_' -OutFile '<somepath>\sqlaccess.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/qds.pdb/c1220065fb9e4e61919175ac9792a2bc2/qds.pd_' -OutFile '<somepath>\qds.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/hkruntime.pdb/f0fd3061c4be4486b3308828ea99276e1/hkruntime.pd_' -OutFile '<somepath>\hkruntime.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/hkengine.pdb/f53682311a4e427ba43cc7908850cf9d1/hkengine.pd_' -OutFile '<somepath>\hkengine.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/hkcompile.pdb/f42433ff7c4b4c52b53875da10d4684e1/hkcompile.pd_' -OutFile '<somepath>\hkcompile.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/SQLOS.pdb/961e76a609b04a7c935cd8ad827f23381/SQLOS.pd_' -OutFile '<somepath>\SQLOS.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
Invoke-WebRequest -uri 'http://msdl.microsoft.com/download/symbols/sqlservr.pdb/e6e24f9a081b42e3b9e22e1f6414b9b22/sqlservr.pd_' -OutFile '<somepath>\sqlservr.cab' # File version 2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
New-Item -Type Directory -Path <somepath>\extracted -ErrorAction SilentlyContinue
expand.exe -r <somepath>\*.cab <somepath>\extracted