Solved

Impact of upgrading SQL Server 2008 R2 edition on existing web applications

Posted on 2014-11-12
2
113 Views
Last Modified: 2014-11-20
We are looking to upgrade the edition of SQL Server 2008 R2 that is installed on one of our production web servers that we maintain. We need to upgrade the edition from Standard to Enterprise.
The reason for the upgrade is the need to use features like Audit logging, TDE, etc.

Before we upgrade, what precautions are recommended to be taken (besides taking a backup of the databases) ?
Since there are applications hosted on the server that use SQL server (we don't have access to the code for all the hosted applications), how to find out if there will be any impact on these applications once the upgrade is done ?
Besides the downtime (which i assume will be there during the upgrade), is there any other thing to be taken into consideration (Server logins, etc.) ?
0
Comment
Question by:ziorinfo
2 Comments
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40437118
Should be an easy and fast task to upgrade the SQL Server Edition. So you just need to find the best window for the downtime (I will say 15 minutes with all the preparation work).
You won't need to worry with other applications because this will only deal with the SQL Server instance. You can expect a clean job here.
Cheers.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 40445812
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question