August 20, 2007 at 9:20 am
I hate to sound so ignorant, but here goes.
I check the status of our SQL Server databases, and noticed that our ReportServer and ReportServerTempDB databases are not being backed up. Should they be? And if they should be, what is a reasonable backup strategy for those databases?
This is for a SQL Server 2005 database.
Kindest Regards, Rod Connect with me on LinkedIn.
August 20, 2007 at 9:24 am
If you are running reports you need to backup both databases or all your reports cannot be recovered because all the RDL are in the catalog table of the ReportServerDB. Hope this helps.
Kind regards,
Gift Peddie
August 20, 2007 at 9:47 am
If you are using Reporting Services then you most certainly should backup the ReportServer db. It contaiins all of the critical info for SSRS including report definitions, report security, schedules, configs, etc. How often you back it up depends on your activity. In my case, we are pretty active with report design right now, so I do hourly tran log backups and a nightly full backup.
The ReportServerTemp db is necessary for SSRS to function, but as its name indicates, it is just used for temporary session oriented storage. I back it up nightly also, although it's probably unnecessary. But I think you need to have a copy somewhere in case it gets trashed, since SSRS won't run without it.
Ed
August 20, 2007 at 11:01 pm
If you need to recover, it will be much easier if you have both databases AND also the encryption keys - you will loose all security information without the key backup.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply