Did you ensure a valid path was listed for the files? The backup file looks for the original path for the files.

If you went to restore over an existing database,...

OK, so when I read that, I think I must have either had encryption go quicker than expected, or missed a block somewhere.

I'd read that as no backups during encryption,...

brickpack (7/7/2016)

---

I read somewhere that I'll need to disable Backups and database maintenance during the encryption process. Is this true?

This is very concerning, since my testing took ~4 days to...

Fourth was quiet. Cut grass, a little volleyball with the family, cooked dinner, watched a few fireworks from the side of the road.

ZZartin (6/29/2016)

---

When Wells Fargo first started doing online banking their default user name was in fact SSN, for years, originally I...

Yep. +100

Thanks for the update. Those are definitely two critical things.

If you don't mind, can you mark your update as the correct answer for future readers?

GilaMonster (7/5/2016)

---

Steve Jones - SSC Editor (7/5/2016)

---

So if you have a 2008 RTM instance and a 2008 SP3 instance, you can restore RTM backups to the SP3 instance, but not...

Well,...

My thoughts: If it's a set structure that needs to be queried often, the deserialize it into relational and store it properly. SQL Server works better with traditional row/col storage...

GilaMonster (7/5/2016)

---

Steve Jones - SSC Editor (7/5/2016)

---

Also, as we've evolved, so have spammers. They change tactics, so there is a race here, and sometimes it's easier to work with what...

The install usually asks you for the folder for the source ISO, not the installed product.

Somehow a log file was not transferred or not restored. Do you still have the missing file?

yes

If the decryption doesn't work, you'll get a NULL. This is poorly documented in BOL, so that's likely your issue.

A couple questions.

1. Are you casting the decryptbykey result to the...