One other option, since there's no sample code and no execution plan, this is speculation. You showed the values passed as being strings '9-1-2009', etc. It's possible that the implicit...

Just remember that backups are very largely a business driven decision, not strictly technology. Talk to the business side of the company to understand what their expectactions of your ability...

Just remember that you have to have FULL backups in place first in order to support log backups.

Sqlfrenzy (5/3/2010)

---

Paul White NZ (5/3/2010)

---

Sqlfrenzy (4/29/2010)

---

top 2 waitstats on one of the server are BackupBuffer and BackupIO. The backup is being done at a network location using symantec backup utility....

Paul White NZ (5/3/2010)

---

1....

Gianluca Sartori (5/3/2010)

---

I think Paul wants to join the "world's worst procedure" competition... :-P.

I would have put some more BREAK / CONTINUE in it and maybe nested another cursor,...

Steve Jones - Editor (5/2/2010)

---

I've seen a couple incidents of plagiarism lately on different sites. Not all from this site, but a few places that have copied info from MSDN/Technet,...

Trey Staker (4/30/2010)

---

@Grant -- are you the same Grant Fritchey that wrote this review on this Garmin GPS unit in 2008? The profile there said something about sql server....

Lynn Pettis (4/30/2010)

---

Steve Jones - Editor (4/30/2010)

---

Lynn,

I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things...

Lynn Pettis (4/30/2010)

---

Grant Fritchey (4/30/2010)

---

Lynn Pettis (4/30/2010)

---

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

Best tool I've found for doing this is Quest's Benchmark Factory. I'm not even sure they still offer it. At one time Idera had a tool for doing this as...

Lynn Pettis (4/30/2010)

---

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

Threads are managed by SQL Server and the operating system.

What is it that you're trying to do?

You are so behind the times... Haven't you heard, Powerpivot in Excel is the new mechanism for database storage & retrieval....

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 fully reading the question, but...