May 29, 2009 at 8:50 am
is it required maintanence plan like Backup optimizations and dbcc checks at all?
Because it stores only temp data and session informatio.
May 29, 2009 at 8:52 am
you asked the question and gave the answer as well ...;-)
in short Its not needed ...
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
May 29, 2009 at 9:40 am
hi_abhay78 (5/29/2009)
you asked the question and gave the answer as well ...;-)in short Its not needed ...
This is the second time I am answering this question and correcting the first answer you need to backup both the ReportServerDB and ReportServerTempDb because you cannot upgrade, move and recover from hardware failure without both. You need to restore both before your new relational engine will initialize SSRS.
Kind regards,
Gift Peddie
May 29, 2009 at 10:26 am
What is different reportservertempdb, from tempdb
i donot see any difference in it.
then why we want to backup and restore it.
i may be missing important peace. correct me
May 29, 2009 at 10:35 am
You are missing the fact that both ReportServerDB and ReportServerTempDb are required for upgrade to new version of SQL Server like 2000 to 2005 to 2008, to move ReportServer to a new computer your new installation of SQL Server will not start your old existing ReportServer without both databases and if you get hardware failure I had two you cannot recover from your old ReportServer without both databases. So backup ReportServerDB with full Recovery and ReportServerTempDB Simple Recovery
Kind regards,
Gift Peddie
May 29, 2009 at 8:07 pm
Or we can say like this (i shoudl have modified my sentence in the begening itself ).The only reason to backup the reportservertempdb is to avoid having to recreate it if there is a hardware failure. In the event of hardware failure, it is not necessary to recover the data in reportservertempdb, but you do need the table structure. If you lose reportservertempdb, the only way to get it back is to recreate the report server database.
So ,keep one or 2 copies as a structure ...
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
May 30, 2009 at 8:15 am
I would do a simple recovery backup regularly because if your reports data change regularly the session data today is not the same the next day and I have not seen upgrade or migration without it.
http://msdn.microsoft.com/en-us/library/ms156016(SQL.90).aspx
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply