Exactly the problem.

SO attempts to solve that by giving points for 'good' and 'correct' answers, and that...

dxmer (6/12/2009)

---

I understand the log gets truncated on a shrink, but I was under the impression that if you initialized the log to a certain size only the logical space...

Log backups do not shrink the log. If the physical size of the log file is dropping then there's a shrink database or shrink file operation somewhere. Check maint plans,...

Compressed backups (either native SQL 2008 or 3rd party)

Differential backups (maybe)

Striped backups (maybe)

File/Filegroup backups

Fast backup drive(s) with enough space to keep one or two

A carefully designed and well tested database...

Pleasure.

About the only regret is that I took a job immediately as I finished my degree. A week after I accepted the job I got an offer for a full...

SADeveloper.net is down, pending a new...

In Bulk logged recovery bulk operations are minimally logged. When the transaction log backup runs, it goes through the database and finds all of the extents that were changed by...

#include "Usual caveats and warnings about using undocumented commands"

Shouldn't be a problem. Log backups can be taken in both full and bulk logged and can restore fine on another server. Just don't switch to simple or you'll have...

Select Col1, Col2, Col3

FROM SomeTable

WHERE Col3 = x

AND Coln < DATEADD (HOUR, -24, GETDATE())

Or have I misunderstood your requirement? If so, please post some sample data and expected...

Have you looked in Books Online? On MSDN[/url] and Technet[/url]?

Read it is a possibility. Expecting everyone to follow the advice might be a little too much to...

Do some googling for the undocumented stored proc sp_MSforeachtable

Sure it can. It's only the LOB data types...