Not sure if it will help, but have you looked into full text indexing?

Sorry, but I can't see from here what you see from there. Little hard to help.

Unless you are having space issues on the disk, don't. If it has grown to that size, it has for a reason. Shrinking it will only make it...

htt (8/13/2009)

---

Until you get to SQL Server 2008 where the truncate option no longer works. Besides, why truncate the log right after you have backed it up? Doesn't...

No. Only transaction log backups will...

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