This has consistently worked for me.
Back it up afterwards....

use dc
go

checkpoint
go

backup log dc with truncate_only
go

dbcc shrinkfile ('DC_Log',TRUNCATEONLY)
go

select * from sysfiles order by name
go




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


Even if you do a full backup right before? Or do I not want to do a
backup right before? Since it might be storing my bloated log file??
Or do I want my bloated log file?

Dan

Albert Frazer wrote:
> ...and of course backup database immediately after.
>
> Albert Frazer
> Home Decor Products, Inc
> www.hdpi.com
> 732-593-3637 (office)
> 732-570-4465 (cell)
>
> -----Original Message-----
> From: Albert Frazer
> [mailto:mssqldba-ezmlmshield-x15599668.[Email address protected]
> Sent: Tuesday, August 28, 2007 6:06 PM
> To: LazyDBA Discussion
> Subject: RE: Shrink my log file!!
>
> That's how I usually do:
>
> BACKUP LOG db_name WITH NO_LOG
> DBCC SHRINKFILE('dbname_log', truncateonly) or DBCC
> SHRINKFILE('dbname_data', truncateonly)
>
> You can substitute truncateonly with the number that you want to shrink
> you data/log file to (in MB)
>
>
> Albert Frazer
> Home Decor Products, Inc
> www.hdpi.com
> 732-593-3637 (office)
> 732-570-4465 (cell)
>
> -----Original Message-----
> From: Dan Guzman
> [mailto:mssqldba-ezmlmshield-x29018599.[Email address protected]
> Sent: Tuesday, August 28, 2007 6: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
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
> ---------------------------------------------------------------------
> 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
>
>



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



--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


MS Sql Server LazyDBA home page