• Increase font size
  • Default font size
  • Decrease font size
Home Reporting Services Back up Data Reporting Services

Back up Data Reporting Services

E-mail Print
(0 votes)

batch_process_2_clock_128 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

Copyright 2008. All Rights Reserved.

Trackback (0)

TrackBack URI for this post

Comment (0)

RSS feed Comments

Write comment

bold italicize underline strike url image quote smile wink laugh grin angry sad shocked cool tongue kiss cry
| groter smaller | bigger
security image
Write the displayed characters

busy