All dates of the reports in your Report Manager are are available in the report server database. So it is wise to back up every day this database.
This can best be done by a SQL Server Agent Job to create and daily scheduling. Enter the following SQL statement on. This ensures that a backup is made every day of the report server information!
- Report Server BACKUP - All reports are in these databases and must be backed up every day! - BACKUP PARAMETERS EXPLANATION: - NOFORMAT: Specifies the media header That Should Not be Written on all - Volumes Used for this backup operation. This is the default behavior. - INIT: Specifies thats all backup sets on Should Be Written, but preserves - The media header. If INIT is Specified, Any Existing Backup Set On That device is overwrite. - STAT: Displays a message Each time completes Another rate, and has been overused to gauge progress. - If rate is omitted, SQL Server displays a message after Each is 10 percent completed. master; USE master; [ ReportServer ] TO DISK = N 'E: \S QL \B ACKUP \R eportServer.BAK' BACKUP DATABASE [ReportServer] TO DISK = N 'E: \ S QL \ B ACKUP \ R eportServer.BAK' NOFORMAT, INIT, NAME = N 'ReportServer' , SKIP, NOREWIND, NOUNLOAD, STATS = 10 WITH NOFORMAT, INIT, NAME = N 'ReportServer', SKIP, NOREWIND, NOUNLOAD, STATS = 10
Note:
The ReportserverTempDB need not be backed up






















Tags 