Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to state right off the bat that I'm not looking for information on how to backup a SQL Server. I've got that taken care of.

I'm looking for some form of documentation that will tell me the steps I need to take/things I need to keep in mind to properly back up a secured (with a 3rd party certificate) SQL Server 2012.

What, other than the actual database information, do I need to send to my backup solution so I can ensure minimal downtime in a worst case scenario (knock on wood)?

share|improve this question
Have you had a read through this? The only reason I ask is because if so then I probably wouldn't post an answer, and if you haven't I recommend that you do. technet.microsoft.com/en-us/library/bb964742.aspxb964742.aspx – Mr.Brownstone Feb 22 at 16:48
It says 'Content Not Found' when clicked. – Techie Joe Feb 22 at 17:02
1  
I have updated the link for you now - sorry about that: msdn.microsoft.com/en-us/library/bb964742.aspx – Mr.Brownstone Feb 22 at 17:26
Ok this I have taken care of but in addition to this I applied a SSL certificate to the server. Unless specifically noted, I don't see how this applies to the SSL scenario. One of my biggest gripes about this product is the lack of good, detailed documentation from MSFT about encrypting a SQL server with a 3rd party SSL and all processes/procedures associated with this including backups. – Techie Joe Feb 22 at 18:29
1  
Sorry, I am a little confused - in your question you say that it is secured with a 3rd party certificate then below you say SSL. Are you talking about database encryption or an encrypted transport layer? What exactly is secured with the certificate and how is that certificate used? – Mr.Brownstone Feb 26 at 20:28

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.