Backup your log file routinely. Set up a Database Maintenance Plan to backup
your transaction log every four hours, for example. This will keep your log
file at a manageable size. It's only growing because you are not backing it
up. You have to keep the log file backups with your database backups or you
won't be able to recover your database to the point in time of a server
failure. Even with four hourly backups you can lose up to four hours worth
of database changes.
You can fix the database transaction log size (in Properties -> Files) by
turning off Autogrow, and you should, but if you don't back it up and it
fills, your database will stop even if your disk is not full. Autogrow is
only for people who don't have time to maintain their databases and such
people are not DBAs. If you don't need to recover the database
up-to-the-minute and you are happy with losing any changes made to the
database since your last database backup, set the recovery model to Simple
and the transaction log will stay quite small.
-----Original Message-----
From: Vijayakumar K - Engineer(Data Center) - SIS
[mailto:mssqldba-ezmlmshield-x85818081.[Email address protected]
Sent: Friday, 30 November 2007 4:42 PM
To: LazyDBA Discussion
Subject: How to reduce log file size and fix to a lower value
Hi Experts
I am having sql 2005 in win 2003 server.
My log file size seems to be 3 GB and it is growing and making the disk
space full.
How to reduce it and fix the same to a lower value ?
Regards
Vijayakumar K
"Vijayakumar K - Engineer(Data Center) - SIS" <vijayakumar.[Email address
protected]
___________________________________________________________________________
Visit us at www.sundaraminfotech.in
___________________________________________________________________________
This E-mail may contain privileged information and is intended solely for
the addressee, and any disclosure of this information is strictly
prohibited, and may be unlawful. If you have received this mail by mistake,
please inform us immediately and delete this mail. Any information
expressed in this mail does not necessarily reflect the views of SUNDARAM
INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy,
unencrypted mail via Internet is not considered secure.
___________________________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page