why on earth would you want to blanket deploy TDE???

friedrichsenm (8/6/2014)

---

I was working on a job to send me info each morning about database file free space and was noticing some odd things when looking at the log file...

vkundar (8/6/2014)

---

To provide more context, on the HA setup we are looking we have two DC one we are planing to be HA and oter will be DR.

I have to...

If you plan a failover, always stop your application services first. Why intentionally rip the database from under the app when you could have a clean shutdown and startup. The...

You're welcome

Protect the cert by backing it up and securely storing the keys. Restoring master across servers has its own ramifications, so don't do it!!

Although if you don't have one clustered the installer stills bitches and moans and produces a...

It happens less and less with the latest versions of Windows...

need to know a bit more about your requirements first, as well as answers to the following

Network connection between sites

Hardware available

DR databases to be readable or offline

This article may help you too http://www.sqlservercentral.com/articles/Transparent+Data+Encryption+(TDE)/91712/[/url]

lallu_jaya (8/5/2014)

---

1. Is...

the most notable are

sql server 2008 now supports service based SIDs for clustered installations when installing on Windows 2008 and above, instead of the old AD based group config used...

lallu_jaya (8/5/2014)

---

Question 1:

I tried moving a TDE database to another server. I only needed a backup and restore of Certificate and the Private key associated with the Certificate.

I did...

muthyala_51 (8/4/2014)

---

Can we stop and start sql server agent based on AG failover ? Instead of editing all the jobs/job steps to check which one is primary before running, it...

Cluster installation has changed radically. SQL server cluster installations are now...

vsamantha35 (8/2/2014)

---

When the private network goes down cluster communications will carry on through the public network. Loss of a private network does not initiate a failover. The loss of the...