Jack Corbett (4/19/2010)

---

Don't usually say this, but going to be in meetings for a few days, so I'll be even less active than I have been recently. Also have...

Guffaw

Kringer

Thanks for the Question

Agreed - network delays can increase backup times as well as failures.

Well, there we have it. Thanks for pointing it all out Stefan and Jeff for testing.

Stefan_G (4/18/2010)

---

Well, on my machine...

I have a sample of what I ran here[/url].

I used a triple cross join to create the results. I didn't post that query...

Matt Miller (#4) (4/18/2010)

---

Steve Jones - Editor (4/18/2010)

---

Grant Fritchey (4/18/2010)

---

I usually is... or maybe all those millions I pay for exclusive rights to use it is...

Stefan_G (4/18/2010)

---

Matt Miller (#4) (4/18/2010)

---

Simply because SQL Server will use disk and/or memory interchangeably as needed. When it runs into memory pressure, it will flush things to disk. ...

Tom.Thomson (4/17/2010)

---

CirquedeSQLeil (4/17/2010)

---

The changes are trivial. The biggest piece of note is that there really is no notes as to the changes made (i.e. dates etc). It still...

One more note on sp-who2, note how little it has changed when SQL server has changed so much.

6.5 version used sysprocesses as well.

Tom.Thomson (4/17/2010)

---

There is very little difference - cosmetic bits (changes of captitalisation, "Exec" instead...

pshaship (4/17/2010)

---

Hi Steve, Jason,

Are you guys do the Full/Diff/log backups to local server or backup to a Network Share?

If you backup local to the server, then if the server goes...

Good luck.