So what is happening is that all activity (updates/deletes/inserts) that occurs between 6:00 PM and the following morning at 8:00 AM are being backed up to the t-log backup run...

nigelc (8/13/2009)

---

Full DB back up is done at 9pm

Then Transactional Log back up starts at 8am next morning. The first back up IE at 8am is around a Gig with...

htt (8/13/2009)

---

here is what I have done for years to my SQL 2000 and SQL 2005 databases: full bk nightly; log bk every 15 minutes from 5 am to 9...

When are the t-log backups run and when is the full backup run?

where employeeid not like '% %'

Full backups and differential backups do not truncate the transaction log of committed transactions. This is only accomplished by the transaction log backup.

My youngest still likes to play tic-tac-toe sometimes, just...

I guess it depends, is it a take home test?

Don't apologize for asking a question. It would be nice, however, if you'd answer the questions asked of you. It would actually help us help you better.

matt stockham (8/13/2009)

---

jpowers (8/12/2009)

---

Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just for our preferred...

There are other ways to move files between servers without using xp _ cmdshell. Would you please explain what you are trying to accomplish and why you think it...

GilaMonster (8/13/2009)

---

jacroberts (8/13/2009)

---

GilaMonster (8/13/2009)

---

Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It...

john.arnott (8/13/2009)

---

Lynn Pettis (8/12/2009)

---

Or, an average of 3GB/day...

steve_melchert (8/13/2009)

---

Steve Jones - Editor (8/13/2009)

---

The "Featured Article" doesn't imply it's the best of the best. It's just the article that we are putting first, as opposed to the links...

I'm sorry, but I have to take exceptioon...