SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Question re: service pack upgrade installation when encryption enabled for dbs


Question re: service pack upgrade installation when encryption enabled for dbs

Author
Message
cjohnson 10812
cjohnson 10812
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 25
Hello. Apologies if this question has been asked before but i am a newbie to the site & forum. I started at a new IT company and during inventory of their db servers i noticed that one of them is behind in its service pack installed. Its version of SQL is: SQL Server 2008 R2 (RTM). And based on some recent stack dumps they've logged & the Non-yielding Resource Monitor errors captured, I know that some of that can be corrected by us just bringing the service pack up to date. At least to Service Pack 1 for 2008 R2 if nothing else. Am i correct on that? Anyway, the actual concern i have is after i test the implementation of Svc Pack1 on one of our test/QA servers, can i expect any complications in upgrading the service pack for this server when all of the dbs on the server are encrypted? Will that jeopardize that encryption configuration or will it be transparent? And in that same vein re: the encrypted databases would we have to re install/restore the certificates created during that encryption after the upgrade? Maybe none of this is a factor but considering i'd be making the svc pack upgrade on a production server i wanted to reach out & ask. Any info anyone might have would be great. Thanks!
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20000 Visits: 17243
You just need to ensure that you have backups of all certificates (public and private keys) and backups of all the databases too. It might also pay to review the release notes for the service pack to get an idea of whats included.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32393 Visits: 18556
Perry Whittle (10/22/2012)
You just need to ensure that you have backups of all certificates (public and private keys) and backups of all the databases too. It might also pay to review the release notes for the service pack to get an idea of whats included.


I just want to reiterate what Perry said. Make sure you have backups of those keys and databases. Worst case scenario without those backups is losing all data in the encrypted database.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20000 Visits: 17243
if you're sensible you already have backups of the above ;-)

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
cjohnson 10812
cjohnson 10812
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 25
Thank you both for the replies. Yes, i've made sure our db backups are being captured daily but will ensure i have a clean set before i start with the upgrade. I know we've saved off backups of the certs & keys in past workplaces & kept them offsite in case of a disaster, so it sounds like i need to make sure that is happening here as well. I'm pretty sure it is but will confirm with the lead DBA here. Thx again for the feedback. That's what i needed to know.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search