Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Archiving Reports

SQL Server 2000

Archiving Reports

Reporting Services does not provide specific features for formally archiving your reports. If you require an electronic copy of a report that is identical to a report that you have distributed, choose one of approaches described in this topic.

Saving Reports

If you have a small number of reports to archive, consider saving a report as a file. You can save a report in a page format (such as PDF or TIFF) and place it in a protected shared directory on the network. Alternatively, you can upload a PDF or TIFF report that you have saved as a resource item if you want to keep all copies of a report, regardless of the format, in the report server database. For more information about saving a report, see Saving Reports.

Using File Share Delivery

If you have a large number of reports to archive, create a subscription that delivers the report to a file. For this approach, you must create a subscription for each report, choose a file share to store the reports, and define a schedule that determines when the file is created. Once you define a subscription, the report server can run the report unattended and add report files to the archive using the schedule that you provide. You can also create single-use schedules if you want to archive reports on an occasional basis. For more information about subscriptions and file share delivery, see File Share Delivery in Reporting Services and Subscription Overview.

Using Report History

You can also use the Report History feature to create historical copies. You can then back up the report server database and store the backup in a safe location for future use. All report history (along with reports, shared data source items, folders, subscriptions, and shared schedules) is stored in the report server database. You can create a backup to maintain a permanent copy of report history and meta data such as subscription information that indicates the recipients of a report.

Log information is not stored in report server database. If you require a permanent record of report runs, you must back up the log files separately.

See Also

Managing Report History

Auditing and Verifying Report Runs

Managing Report Server Content

© 2015 Microsoft