Recovering Reports

I had an unfortunate situation where a downed server resulted in a
significant amount of lost work (the rdl files of several reports I had been
working on).
I had previously uploaded them to the reporting services server and had
hoped that I could recover them from there - but I can't find them anywhere.
Is there a mechnaism for recovering rdl files (or at least the sql behind
them?) from the reporting services server?I beleive it is stored in an image field named Content in the Catalog table
of your reporting server database
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Kwebster" <Kwebster@.discussions.microsoft.com> wrote in message
news:4DBD3671-64E8-4159-8887-D26B59C18D89@.microsoft.com...
> I had an unfortunate situation where a downed server resulted in a
> significant amount of lost work (the rdl files of several reports I had
been
> working on).
> I had previously uploaded them to the reporting services server and had
> hoped that I could recover them from there - but I can't find them
anywhere.
> Is there a mechnaism for recovering rdl files (or at least the sql behind
> them?) from the reporting services server?|||Are the reports still showing up when you go to the report manager site? If
so, you can go to the properties -> general page of each report and click on
the edit link under report definition and save as.
"Kwebster" wrote:
> I had an unfortunate situation where a downed server resulted in a
> significant amount of lost work (the rdl files of several reports I had been
> working on).
> I had previously uploaded them to the reporting services server and had
> hoped that I could recover them from there - but I can't find them anywhere.
> Is there a mechnaism for recovering rdl files (or at least the sql behind
> them?) from the reporting services server?|||Hello Daivd. A thousand thank you's - worked perfectly.
"David Siebert" wrote:
> Are the reports still showing up when you go to the report manager site? If
> so, you can go to the properties -> general page of each report and click on
> the edit link under report definition and save as.
> "Kwebster" wrote:
> > I had an unfortunate situation where a downed server resulted in a
> > significant amount of lost work (the rdl files of several reports I had been
> > working on).
> >
> > I had previously uploaded them to the reporting services server and had
> > hoped that I could recover them from there - but I can't find them anywhere.
> >
> > Is there a mechnaism for recovering rdl files (or at least the sql behind
> > them?) from the reporting services server?|||Hrllo Wayne
Thank you - learn something new everyday!
"Wayne Snyder" wrote:
> I beleive it is stored in an image field named Content in the Catalog table
> of your reporting server database
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Kwebster" <Kwebster@.discussions.microsoft.com> wrote in message
> news:4DBD3671-64E8-4159-8887-D26B59C18D89@.microsoft.com...
> > I had an unfortunate situation where a downed server resulted in a
> > significant amount of lost work (the rdl files of several reports I had
> been
> > working on).
> >
> > I had previously uploaded them to the reporting services server and had
> > hoped that I could recover them from there - but I can't find them
> anywhere.
> >
> > Is there a mechnaism for recovering rdl files (or at least the sql behind
> > them?) from the reporting services server?
>
>