If you do not require transactional recovery ability, you might use
simple recovery mode. If you do, constantly shrinking the log file to
have it grow back might not be the best performance minded thing to do.
If you can increase the frequency of your log backups, that might be the
best idea to keep them smaller but also retain point in time recovery
ability.

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I do require transactional recovery ability, so simple mode is out.
I am doing tran log backups every hour, would every 10 minutes be a
better suggestion? What do others do? This dB isn't so critical that
an hours worth of transactions lost wouldn't be too bad.

D.

Ray Higdon <rayhigdon@higdonconsulting.com> wrote in message news:<3f394ca7$0$192$75868355@news.frii.net>...
> If you do not require transactional recovery ability, you might use
> simple recovery mode. If you do, constantly shrinking the log file to
> have it grow back might not be the best performance minded thing to do.
> If you can increase the frequency of your log backups, that might be the
> best idea to keep them smaller but also retain point in time recovery
> ability.
>
> Ray Higdon MCSE, MCDBA, CCNA
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

D. Buck (triumpht5@yahoo.com) writes:
> I do require transactional recovery ability, so simple mode is out.
> I am doing tran log backups every hour, would every 10 minutes be a
> better suggestion? What do others do? This dB isn't so critical that
> an hours worth of transactions lost wouldn't be too bad.

What size is the database? If you can afford to lose a few hours of
data you could run a full backup every three hours or so and the
switch to simple recovery mode.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

I have databases I back up the log every 15 mins, Erland's suggestion of
more frequent log backups would work fine

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

"Ray Higdon" <rayhigdon@higdonconsulting.com> wrote in message
news:3f3b83ca$0$198$75868355@news.frii.net...
> I have databases I back up the log every 15 mins, Erland's suggestion of
> more frequent log backups would work fine

Same here. (I'm actually thinking of taking one DB down to every 5 or 10
minutes for a log-shipping application.)

I have others setup for every hour that if I ever setup log-shipping for
them I'll also move down to 5-10 minutes.

In the long run, I've found this keeps log sizes more consistent and
performance remains fast.


>
> Ray Higdon MCSE, MCDBA, CCNA
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!