You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an
Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel
Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware
requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Migrate SSRS content to a separate instance of SSRS 2012 on the same server.
B.
Perform an in-place upgrade of the SSRS environment.
C.
Migrate SSRS content to new servers that run SSRS 2012.
D.
Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
I think You can perform an in-place upgrade from SQL Server 2008 R2 Reporting Services integrated with a SharePoint Server 2010 farm to SQL Server 2012 Reporting Services with no
downtime.
https://msdn.microsoft.com/en-us/library/ms143747(v=sql.110).aspx
I think C is not correct cause you have to consider the hardware requirment also.
I think A is the best choise. No downtime and no additional hardware.
After the testing of a new instance you can remove the older installation.
By the way side by side installations of ssrs supported
if you upgrade to sql 2012.
In sql 2014 side by side upgrade from any of previous version is unsupported.
So be carefull.
B:
https://msdn.microsoft.com/en-us/library/61290949-690a-4e19-b078-57c99b6b30fa(v=sql.110)
“SQL Server 2008 R2 to SQL Server 2012
Starting environment: SQL Server 2008 R2, SharePoint 2010.
Ending environment: SQL Server 2012, SharePoint 2010.
In-place upgrade is supported and there is no down time for your SharePoint environment.
Install the SQL Server 2012 version of the Reporting Services add-in for SharePoint on each web front-end in the farm. You can install the add-in by using the SQL Server 2012 installation wizard or by downloading the add-in.
Run SQL Server 2012 installation to upgrade SharePoint mode for each ‘report server’.The SQL Server installation wizard will install the Reporting Services Service and create a new Service application.”
A:
https://msdn.microsoft.com/en-us/library/61290949-690a-4e19-b078-57c99b6b30fa(v=sql.110)
If you have a Reporting Services installation integrated with SharePoint 2010, you cannot upgrade in-place the SharePoint server.
A
https://msdn.microsoft.com/en-us/library/ms143747(v=sql.110).aspx#bkmk_sharePoint_scenarios
SQL Server 2008 SP2 to SQL Server 2012
Starting environment: SQL Server 2008 SP2, SharePoint 2007.
Ending environment: SQL Server 2012, SharePoint 2010.
This in-place upgrade scenario does require down time of the SharePoint environment because both the SharePoint and SQL Server technologies need to be upgraded. You may want to consider completing a migration rather than an in-place upgrade.
Upgrade SQL server 2008 to Service Pack 2 (SP2) first, if that has not already been completed.
Upgrade SharePoint to 2010. When you run the SharePoint 2010 prerequisite installer it will upgrade the Reporting Services add-in for SharePoint 2010 products.
Install the SQL Server 2012 version of the Reporting Services add-in for SharePoint on all SharePoint web front-ends. The SharePoint pre-requisite installer installed the SQL Server 2008 R2 version of the add-in but you need the SQL Server 2012 version to work with a SQL Server 2012 report server.
Side-by-Side upgrade method for SSRS Sharepoint integrated mode is not supported for all versions.
I think B.
Perform an in-place upgrade of the SSRS environment.