So, after I have log shipped the transaction logs to the destination
server, I should truncate my logs. Correct? If I do that and
"something" happens to my database on the primary server, I can restore
from my last backup but I will have no transaction logs available to
apply to bring my database forward to the point of failure. Is that
correct?
Please explain why in a database that has log shipping, the used space
in the log file continues to grow and a database that does not have log
shipping, the used space in the log file does not?
I must be missing something. Please advise.
Thanks,
Maureen
-----Original Message-----
From: Richard Tabar
[mailto:mssqldba-ezmlmshield-x49632906.[Email address protected]
Sent: March 27, 2007 11:14 AM
To: LazyDBA Discussion
Subject: RE: Log Shipping using SQL 2000 SP3a
Correct. Thanks for adding that crucial step to my answer.
-----Original Message-----
From: Jay Butler
[mailto:mssqldba-ezmlmshield-x52907638.[Email address protected]
Sent: Tuesday, March 27, 2007 10:11 AM
To: LazyDBA Discussion
Subject: RE: Log Shipping using SQL 2000 SP3a
Backing up the transaction log (with or without truncation_only) only
remove the entries from the log. If the file has grown larger than it
needs to be, you can shrink it with the DBCC SHRINKFILE command.
Jay
From: Richard Tabar
Sent: Tue 27-Mar-07 09:40
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
---------------------------------------------------------------------
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 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.
MS Sql Server LazyDBA home page