January 19, 2009 at 9:53 pm
I am updating the backup strategies for a production server and am looking for some guidelines on backing up the ReportServer database for SQL Server Reporting Services for SQL Server 2005.
The application databases that are in use in conjunction with the report server are modified frequently throughout the day and are going to be scheduled for Nightly Full backups and during the day Hourly Differentials and 15 minute Log backups.
Is there benefit to backing up the ReportServer database as frequently as the application databases?
Any information or links to articles/discussions on this would be much appreciated. I have only been able to find information on HOW to backup and restore the databases but not WHEN.
January 19, 2009 at 10:06 pm
Backups preserve changes, so is the Report Server database changing often?
I'd mention that if space isn't an issue, and not likely to be, I try to get backups of different databases on the same schedule to make it easier to manage. If you know all user databases are backed up on schedule A, easier to recover any of them.
Fit it into a system or user database category and then manage it like the others in that group.
January 20, 2009 at 12:13 am
I'd start by including it with my system database backups with the addition of some log backups. Then I'd monitor log growth and adjust my log backups as needed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 21, 2009 at 6:00 pm
You would have to look at your business requirements and then determine how much data loss is acceptable? In those lines you need to design your Backup strategy, but more frequent backups will reduce the loss of data and also speeds up your recovery time......
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply