RE: Shrink my log file!!

RE: Shrink my log file!!

 

  

Indeed. You need to do full backup since you've truncated your
transaction log.
And you can keep your previous full backup until you have successful
backup after the truncation.


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-x99285600.[Email address protected]
Sent: Tuesday, August 28, 2007 6: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


MS Sql Server LazyDBA home page