I would have two dream machines, one for work use, and one for personal use...

My work box would just be a desktop, support 2+ monitors, LOTS of RAM and a...

A DOS batch file run with Windows Task Scheduler.

Here's one I came up with, it does require that you have pkzip / pkzipc / pkunzip somewhere in your path, though....

Once more, thank you. I hadn't thought about what would be required to restore the DB (and still be able to access the encrypted data) until after your post.

With...

OK, so Express can for sure encrypt by passphrase, so I'm expecting it will work by certificate as well.

Yup, it does work by certificates as well...

Once more, thank you!

Jason A.

Thanks! I always forget to check BOL...

I just completed loading up SQL Express on my PC, and will be testing this out.

Jason A.

Lions

My stand on it would be, who's going to be supporting the configuration?

If it's you, and you aren't familiar with / comfortable with setting up VMWare and managing it (I'd...

Possibly the easiest way, if you've got physical access / control to the server, is going to be to unplug it from the network until you're done. Bear in...

Escheresque

Cliff Jones (8/21/2012)

---

crookj (8/21/2012)

---

Scott D. Jacobson (8/21/2012)

---

Daniel Bowlin (8/21/2012)

---

ChrisM@Work (8/21/2012)

---

Ray K (8/21/2012)

---

ChrisM@Work (8/21/2012)

---

Green...

Bulette!

(Landshark)

After reading this, especially the section on "Poor...

Yeah, I know what they say about assumptions...

Ouch.

My hope is that I'll never need to worry about this, that the system will rarely need to be restarted and that the...

It was primarily to be able to give a rough estimate of how long it might take for a system to be ready to use again for all the DBs...

GilaMonster (8/13/2012)

---

They recover in parallel. Multiple spids are spawned to recover each of the user databases. User databases will only get recovered after the system ones are recovered.

You can see...