Optimization Blows up T-Log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David J. Cartwright - 19 Dec 2005 16:25 GMT

Is it normal for an opti job to blow the T-log on a 80GB db to 50 GB from
2GB?

Reply to this Message

David J. Cartwright - 19 Dec 2005 16:31 GMT

sorry wrong group

> Is it normal for an opti job to blow the T-log on a 80GB db to 50 GB from
> 2GB?

Reply to this Message

Andy Davis - 21 Dec 2005 04:47 GMT

Hi,
it *depends* , what is your Recovery Model ?! is your application write
intensive !? are you doing any Bulk Logged ?! are you doing Index Tunning /
defregmentation as Maintanance Plan !?
To Reduce size of T-Log take a regular T-Log backup , say every 30 mins .

Regards

Signature

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com

Reply to this Message