Solved

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

Posted on 2014-11-12
2
106 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 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
Comment Utility
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
Comment Utility
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now