Shriniket (4/30/2010)

---

In the recovery steps use of "latest differential backup" is misleading; I know it does say Tuesday @4pm but shouldn't the "latest differential" be Wednesday @8am? What would be...

I can understand some people misreading the question or going to fast, but for close to 50% to get it wrong, just seems a bit wrong. Late last night...

CirquedeSQLeil (4/30/2010)

---

tosscrosby (4/30/2010)

---

CirquedeSQLeil (4/30/2010)

---

Lynn Pettis (4/30/2010)

---

Should I be scared? Nearly half of those who have answered the QotD have gotten it wrong. Could be people not...

Should I be scared? Nearly half of those who have answered the QotD have gotten it wrong. Could be people not fully reading the question, but still, this...

Thanks. I guess I'm glad I haven't taken any of the certification tests.

SQL Dude-467553 (4/30/2010)

---

I think this question really makes me think. I thought the log backup chain was broken after a full backup based on this I read on MSDN

"If...

hanziou (4/30/2010)

---

Lynn Pettis (4/30/2010)

---

.

.

.

Full and differential backups do not break the log chain of transaction log backups. In this scenerio, the Tuesday night backup is corrupt, and you need...

Sounds to me like you are trying to change the Employee Number to a value that already exists in the database. Try running a SELECT statement on the table...

Grant Fritchey (4/30/2010)

---

Lynn Pettis (4/29/2010)

---

dbowlin (4/29/2010)

---

Thanks Grant, this is helpful.

Someone on LinkedIn referred me to Blythe a little earlier today. I sent her an email asking for details.

I am...

anilkullam (4/30/2010)

---

[font="Comic Sans MS"]Hi Lynn & everybody else..

As for as my knowledge is concerned, a differential backup shud have a base to start with, which is necessarily the recent full...

Was really looking for a date or at least day when this...

G'nite all, I have to get up early today.

We missed the party!! When did we break the 1,250,000 member mark??

CirquedeSQLeil (4/29/2010)

---

Thanks Lynn.

The part that gets me with these questions is if the hardware failure was enough to corrupt the database and the full backup - it would seem to...

Saw your response on the thread. Probably could have used more detail on the hardware to support a failure corrupting...