Post reply

Deleted a folder accidently in SSRS _ Is there a way to recover the lost data

  • December 16, 2011 at 12:00 pm

    #247829

    Anyone:

    A folder and a bunch of reports got deleted. Is there a way to get the reports back ?

    Please ?

  • December 16, 2011 at 12:34 pm

    #1422681

    Do you have one of the following:

    1. Database Backup?

    2. The RDL files?

    If No, then it is a matter of recreating the reports.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 16, 2011 at 12:46 pm

    #1422690

    I believe when something is deleted it goes to the transaction log.

    So if we had a tool to get the deleted info we could restore it back. Don't you think ?

  • December 16, 2011 at 12:49 pm

    #1422693

    You could try it that way, but the data for those reports is spread across several tables and recreating it is sometimes difficult.

    It is far easier to have the rdl in source and redeploy or restore from backup.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply