recovering deleted data sources ssrs-2008 -


i have deleted mistake data source folder. forder many data sources were.

two questions:

1) how can find reports need data source on folder?

2) there way recover data source folder?

thanks , regards marcelo

if have backup of report server database need restore , data sources there.

to find reports using datasource can run query on reportserver database:

select * catalog  content not null  , convert(varchar(max), convert(varbinary(max), content)) '%<datasourcereference>%' + @yourdatasource + '%</datasourcereference>%' 

Comments