Hi all

I am trying to back up my files from reporting server

My question is that where I can find files that i have deployed in my reporting server

Thanks

Hello,

The Below Query returns the Data in Your Repor server

"SELECT Path, Name,
Type = CASE Type WHEN 2 THEN 'Report'
WHEN 6 THEN 'Report Model' END,
SourceCode = CAST(CAST(content AS VARBINARY(max)) AS XML)
FROM ReportServer.dbo.Catalog
WHERE Type IN (2,6)
ORDER BY Path, Type, Name "

There is a ReportServertb, In that Catalog Table Stores the information about the rdl files.

Hope this helps