Just curious, why would you take a differential immediately after a full? There can be little or no changes between the two.

Basically, if you have a differential that you mean...

Your estimated & actuals are a bit off, especially at the end of the query. Are your statistics up to date?

The amount of data you're moving seems to be leading...

Alvin Ramard (9/1/2010)

---

Lynn Pettis (9/1/2010)

---

GSquared (9/1/2010)

---

Here's an interesting one. This is the list of skills someone wants for their "DBA":

Must have advanced proficiency and extensive knowledge of web development...

Brandie Tarvin (9/1/2010)

---

Grant's comment leads me to this question: What do the rest of you do if you get a call, or linked in mail, but aren't looking for a...

CirquedeSQLeil (9/1/2010)

---

Grant Fritchey (9/1/2010)

---

GSquared (9/1/2010)

---

Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do that literally, but you get...

GSquared (9/1/2010)

---

Connections via SSC and LinkedIn have got my phone ringing off the hook (well, the phone isn't old enough to do that literally, but you get the idea) from...

goksly (9/1/2010)

---

Some reports need to be real time but most do not (a day late isn't a killer).

I do like the idea of a view, but do I have any...

pankushmehta (8/31/2010)

---

pankushmehta (8/31/2010)

---

If your database is in full recovery mode, you can backup the Transaction log and then shrink the file.

If your database is in simple recovery mode, you can...

WayneS (8/31/2010)

---

Just a wee bit over 2000 to go to get it by 11/18 - 2.5 months is...

No, it shouldn't. If you've got appropriate log backups in place, in general, the size of the log is how big it needs to be to suppor the transaction load...

CirquedeSQLeil (8/31/2010)

---

homebrew01 (8/31/2010)

---

In this case it...

Probably that's the original size of the log file. You can't shrink below the original file size (well, not without other work & stuff, just go with it). You'd need...

9 Million tables?

I suspect that's the issue. I've never even heard of a database with that many tables. I'm not sure what kind of problems you can expect to see...

I'm in agreement with Gail. Just because they're currently in a potentially dire position doesn't mean they wish to remain there. The best recommendation is to have them get together...

Great googly moogly, it's the answers that are getting dangerous now... Yeah, let's put the production database to simple recovery... yikes!