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


MS Sql Server LazyDBA home page