I am looking for specific documentation on how to restore a mission critical
Report Services environment in the event of a catastrophic failure.
Thanx in advance,
GregOn Sep 8, 12:25 pm, "SurferJoe" <Surfer...@.newsgroup.nospam> wrote:
> I am looking for specific documentation on how to restore a mission critical
> Report Services environment in the event of a catastrophic failure.
> Thanx in advance,
> Greg
This article should help.
http://msdn2.microsoft.com/en-us/library/ms155814.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||> http://msdn2.microsoft.com/en-us/library/ms155814.aspx
This article and subsequent topics contained therein do not give specific
restore step-by-step instructions.
I am attempting to restore/migrate a report services installation in a
testing environment to see if it will work, so far no success:(
Thanx,
Greg|||Hello Greg,
In the article Martinez provided, you could see that we need to backup the
reporting services databases. From your description, it seems that you want
to move the reporting services to another server. This more like migrate
the reporting services.
There is a step by step instruction for migrating SQL 2000 reporting
services to SQL Server 2005 reporting services. You could also follow the
steps to migrate Reporting Services 2005 to 2005.
Migrating Reporting Services
http://msdn2.microsoft.com/en-us/library/ms143724.aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||This article speaks better to what I am trying to do;
http://support.microsoft.com/kb/842425
These articles are weak on exact restore procedures;
http://msdn2.microsoft.com/en-us/library/ms155814.aspx
http://msdn2.microsoft.com/en-us/library/ms143724.aspx
I have the databases and symmetric key successfully "restored/migrated" to
the new computer running under a different named instance of SQL server.
The remaining problem is how to get the browser or ASP folder structure
"restored/migrated" to the new computer. It not real clear just where this
information is stored for retrieval by the browser.|||Hello Greg,
I am not sure what ASP folder structure you mean. If you mean the report
manager and report server virtual directory, you don't have to move them
because you need to install reporting services in the new server which will
create those 2 virtual directories.
All the report information is stored in the ReportServer and
ReportServerTemp databases. In the KB article you found, it indicate that
you need to move the database to the new server. So all the information
will move to the new server.
Hope this is clear and if you have any question, please feel free to let me
know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||In nutshell;
The report services databases symmetric key and the virtual directory
information were all backed up from machine (E).
The report services databases and symmetric key were then restored to
machine (M).
After this "Report Services Configuration Manager" indicated that both
machine (E) & (M) were initialized and no changes could be effected using
"Report Services Configuration Manager".
The instructions contained in this article
http://support.microsoft.com/kb/842425 were followed eliminating machine
name (E) from initialized instances.
Report Services seems to be running correctly now on machine (M) with the
data and symmetric key restored from machine (E).
The Report Services Folder Structure available via IE / Report Manager does
not reflect that of the source server machine (E).|||Hello Joe,
Thanks for the update and sharing. If you have any questions, please feel
free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
