Find saved data of SharePoint list in SQL Server

Question

Could you please halp my find saved data of SharePoint list in SQL Server? Where is Sharepoint list data stored in SQL Server

Thanks in advance! Have a greate day!

moe · Accepted Answer · 2017-12-22 08:18:00Z

1

Example:

SELECT TOP 100 * FROM [WSS_Content_portal].[dbo].AllUserData
WHERE tp_LIstId='935B9940-3063-49DC-90D8-2AEE147A069D'

Then parse xml data

moe

5,27722 silver badges34 bronze badges

answered Dec 22, 2017 at 8:06

Aleksandr Khoba

131 silver badge5 bronze badges

Hellofiona_MSFT · Accepted Answer · 2017-12-18 10:50:17Z

0

SharePoint data are stored in the relevant Content Database of web application in SQL server.

Check the article for tables in Content database: Inside a SharePoint Content DB

answered Dec 18, 2017 at 10:50

Hellofiona_MSFT

3,9761 gold badge9 silver badges8 bronze badges

2 Answers 2