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...

Jeff Moden (5/28/2011)

---

What did it do...

We're fine. Horses have been on property for weeks, so...

bitbucket-25253 (5/27/2011)

---

Steve did you drive that '92 240D in Virginia when you lived and worked there. If so, you might have seen another same model, year '80 with a...

Jack Corbett (5/27/2011)

---

Sure, I could go, and attend the precon and the spotlight!

Side note for those not on Twitter, I...

bitbucket-25253 (5/27/2011)

---

Driving a Mercedes 300 1992 (Diesel with super charger) now at 303,562 miles. Change oil every 5,000 ... maintence every 10,000 costs $90.00, and runs like a charm...

Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

A friend of mine says that what a friend of his does is buy old clunker cars, usually for around $2,000 or so. Then the only...

The passwords in native SQL Server backups are weak.

I was thinking more of managing the encryption keys/passwords for third party tools that encrypt the backups. Tools like SQL Backup...