Ellen-477471 (7/16/2013)

---

From all the discussion it still seems like aside from having the backup of the certificate file that was saved with the private key by password "abc123"

that when...

Revenant (7/16/2013)

---

Steve Jones - SSC Editor (7/12/2013)

---

It's worded poorly in BOL.

Essentially on the source you:

- create master key (protected by SMK) in master.

- create cert, protected by DMK (master key).

-...

The first shot was fired.

That's about all we can say. Anything else is guesswork, hearsay, and likely self-serving.

As Jeff said, we're all in this together. Devs and DBAs need...

thanks for the update. Any resolution steps others could try?

BTW, an interesting read here: http://stratechery.com/2013/why-microsofts-reorganization-is-a-bad-idea/

dg81328 (7/14/2013)

---

There are a few things to consider about Microsoft's reorg that put the thing in perspective.

1) they do this every few years

2) it does not change the patterns that...

hany.helmy (7/14/2013)

---

In the explanation it was mentioned the following: "The DEK is inside the backup", to be honest I am not an expert of (Transparent Data Encryption), but I am...

L' Eomot Inversé (7/12/2013)

---

Personally I find it very hard to understand why, some years ago, the USA government/administration decided to instill into operatives in its federal services an attitude to...

I'm not sure what you mean about insecure if you have the cert without the password. You could have a blank password, but in that case you'd technically have the...

Sean Lange (7/12/2013)

---

Greg Edwards-268690 (7/12/2013)

---

Sean Lange (7/12/2013)

---

Steve Jones - SSC Editor (7/11/2013)

---

I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in...

Use the import wizard to get you started.

Or look through the Stairway here. It does an incremental load that might help

http://www.sqlservercentral.com/stairway/72494/

It's worded poorly in BOL.

Essentially on the source you:

- create master key (protected by SMK) in master.

- create cert, protected by DMK (master key).

- you backup the cert, decrypting it...

no need to apologize and glad you got it figured out.

you've got the right solution. Move backups, restore.

Also, script out logins (sp_helprevlogin) and move those. Watch out for linked servers,...

I believe you need to drop and reconfigure replication with a new distributor. You should have scripted out replication as soon as it's set up since problems can result in...

the thing to do, IMHO, is have a series of passes in the data, with a few procs/functions, that handle different items. This one posted looks good, but I bet...