Did you know you can shrink a transaction log even when log shipping?
Posted
by simonsabin
on SQL Blogcasts
See other posts from SQL Blogcasts
or by simonsabin
Published on Wed, 10 Mar 2010 16:08:45 GMT
Indexed on
2010/03/11
17:20 UTC
Read the original article
Hit count: 227
David's posted a great post on shrinking the transaction log and log shipping. Log shipping and shrinking transaction logs
Unlike shrinking the data file shrinking the transaction log isn't a bad thing, IF you don't need the log to be that size.
I've seen many systems that shrink the log because it has grown only for it to grow the next day to the same size becuase of an overnight operation.
To reduce the growth of the transaction log you need to do one or more of the following,
1.Back it up more frequently
2.Change to simple recovery model
3.Use
minimally logged operations
4.Keep transactions short and small
5.Break
large transactions into smaller transactions
6.If using replication ensure
that your backup of the replication topology is frequent
enough
© SQL Blogcasts or respective owner