Occasionally I run across one that is similarly intransigent. When I
do, I set the DB to Simple recovery mode, issue a TSQL CHECKPOINT
command, shrink the log file, reset the recovery mode, and backup the
DB.


==+==+==+==+==+==+==+==+==+==+==
Brendt W. Hess
Database Administrator, Motosport, Inc
brendt.[Email address protected]
==+==+==+==+==+==+==+==+==+==+==

-----Original Message-----
From: Dan Guzman
[mailto:mssqldba-ezmlmshield-x29018599.[Email address protected]
Sent: Tuesday, August 28, 2007 3:04 PM
To: LazyDBA Discussion
Subject: Shrink my log file!!

Ive tried full backups, then log backups, then full backups again. I've
tried Shrink files on the data and on the log file, nothing seems to
shrink this file. It's a 6 Meg database, with an 8 gig log file. I
would like to do this properly, so please, any suggests would be
helpful.

Dan



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