I ususally run the following as a job step immediately prior to the
full backup...

/*
Start - Truncate Log
*/
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY

/*
Shrink LogFile
*/
USE MyDatabase

dbcc shrinkfile(2,2)

USE master
/*
End
*/

This also keep my full-backup file size minimal

-robert

-----Original Message-----
From: Richard Tabar
[mailto:mssqldba-ezmlmshield-x45704803.[Email address protected]
Sent: Tuesday, March 27, 2007 6:40 AM
To: LazyDBA Discussion
Subject: RE: Log Shipping using SQL 2000 SP3a

To shrink the transaction log I use the following command.

backup log truncate_only


-----Original Message-----
From: Jowett Maureen E
[mailto:mssqldba-ezmlmshield-x76589469.[Email address protected]
Sent: Tuesday, March 27, 2007 9:11 AM
To: LazyDBA Discussion
Subject: Log Shipping using SQL 2000 SP3a

Hi,



My database is set to Full Recovery and a full backup is done nightly.
This database participates in log shipping, so transaction logs are
shipped every 1 hour. The transaction log has grown to approximately 25
GB. How do I shrink the transaction log?



Regards,



Maureen Jowett

----------------------------
This e-mail communication (including any or all attachments) is intended
only for the use of the person or entity to which it is addressed and
may contain confidential and/or privileged material. If you are not the
intended recipient of this e-mail, any use, review, retransmission,
distribution, dissemination, copying, printing, or other use of, or
taking of any action in reliance upon this e-mail, is strictly
prohibited. If you have received this e-mail in error, please contact
the sender and delete the original and any copy of this e-mail and any
printout thereof, immediately. Your co-operation is appreciated.

Le present courriel (y compris toute piece jointe) s'adresse uniquement
a son destinataire, qu'il soit une personne ou un organisme, et pourrait
comporter des renseignements privilegies ou confidentiels. Si vous
n'etes pas le destinataire du courriel, il est interdit d'utiliser, de
revoir, de retransmettre, de distribuer, de disseminer, de copier ou
d'imprimer ce courriel, d'agir en vous y fiant ou de vous en servir de
toute autre facon. Si vous avez recu le present courriel par erreur,
priere de communiquer avec l'expediteur et d'eliminer l'original du
courriel, ainsi que toute copie electronique ou imprimee de celui-ci,
immediatement. Nous sommes reconnaissants de votre collaboration.


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