Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
How do i upgrade sql 2008 r2 exterprise 10.52.4000 to 2014 enterprise or 2016
Hi Experts,
I am having problems upgrading sql 2008 r2 enterprise SP3 10.53.6000.34 to any later version of SQL server. I would like to upgrade to Sql 2014 enterprise but I can't get the 2014 full version evaluation edition to work. Â The error is FAILURE: "SQL 2014 Feature Upgrade"
Any suggestions would be greatly appreciated
Error in log
<RunRuleResult ruleName="FeatureUpgradeMa
I am having problems upgrading sql 2008 r2 enterprise SP3 10.53.6000.34 to any later version of SQL server. I would like to upgrade to Sql 2014 enterprise but I can't get the 2014 full version evaluation edition to work. Â The error is FAILURE: "SQL 2014 Feature Upgrade"
Any suggestions would be greatly appreciated
Error in log
<RunRuleResult ruleName="FeatureUpgradeMa
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Hi Arnold,
Thanks for the response.
I have hundreds of SSRS reports so I thought upgrade would be the best option. Â If I install as a new version, how do I migrate all the reports just deploy them all again? Â I have tried restoring a reportserver.bak file but it says its the wrong backup version when trying to restore a 2008 r2 to a new sql 2014 instance. Â It all seems a bit of a nightmare....
Thanks for the response.
I have hundreds of SSRS reports so I thought upgrade would be the best option. Â If I install as a new version, how do I migrate all the reports just deploy them all again? Â I have tried restoring a reportserver.bak file but it says its the wrong backup version when trying to restore a 2008 r2 to a new sql 2014 instance. Â It all seems a bit of a nightmare....
export/import
See if the discussion on disaster recovery addresses your issue.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eac4d7d2-eb7b-421f-8042-1ed93f2ca761/how-to-backup-and-restore-ssrs-2008-r2-reports-server-settings?forum=sqlreportingservices
upgrade has one good outcome where everything goes through with out an issue, there are many more possibilities that something could go wrong at which you are stuck.
Is there a requirement that you transition to the new version of SQL because of the application vendor, or it is because of a ......
See if the discussion on disaster recovery addresses your issue.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/eac4d7d2-eb7b-421f-8042-1ed93f2ca761/how-to-backup-and-restore-ssrs-2008-r2-reports-server-settings?forum=sqlreportingservices
upgrade has one good outcome where everything goes through with out an issue, there are many more possibilities that something could go wrong at which you are stuck.
Is there a requirement that you transition to the new version of SQL because of the application vendor, or it is because of a ......
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.