mar10br0 (6/1/2011)

---

Hi Steve, agree with you in almost all aspects. But, "If a cloud vendor's employees can access your files, so can a hacker that gains access". Well yes, but...

My new Sig:

Steve Jones, FUBAR, SNAFU, Zzzzzzzz

Kiara (5/31/2011)

---

Well, of course...

Anything in the SQL Server error log?

LOL, yep, people get...

Assertions are a great extra check, Eric. Thanks for the note.

Fair points, Elliot and it's one of the reasons I'm annoyed that TDE isn't in other editions. This is great for protecting the data at rest for situations where it...

there isn't anything wrong with what you see, nor will there be from our perspective. What you need to do is take these comments and run them against both servers...

Victor Kirkpatrick (5/31/2011)

---

Had to bone up on TDE to get this one... which btw, is exactly what Steve is looking for in the QOD anyway, right? Good question. Learned a...

If you've never done it, use the Profiler utility to connect to the server and start a basic trace (File New) against the server. This will tell you what commands...

Run a trace when the application connects, see what is happening and check the same code on the main server, perhaps something is missing.

Ultimately you do have to make some decisions on what to keep. Can your systems go back 2 weeks and still work? Or course, but if you go back that...

Glad you enjoyed it. This is one of those tricky subjects.

Is this what you mean? Note that it doesn't cascade the values forward.

CREATE TABLE Foobar

( a1 datetime

, a2 datetime

, a3 datetime

, a4 datetime

, a5 datetime

)

GO

INSERT foobar (a1) SELECT '1/1/2011'

INSERT...

I recommend keeping 2 fulls and the logs since around. After that, I've never seen the need to recover a database in the past to a point in time, so...