Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
melaniemayfield
Starting Member
2 Posts |
 Posted - 2013-09-03 : 18:05:31
|
I have a server with multiple databases which have mirroring configured as well as logshipping configured to another location. The primary database is in FULlL recovery, my concern is the database log file, I have read that you need to do regular log back ups to ensure the database log file does not grow (I assume that logs shipping will take care of this?) , however the log file seems to be growing daily, do I need to shrink the log file periodically on the primary? Can you shrink the log file on a database which has mirroring configured? Any help would be great as all of my research seems to be contradicting itself!Many Thanks in advance....Melanie |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-09-03 : 18:10:10
|
| Yes log shipping should be taking care of this, but you need to monitor the jobs to make sure it still happens.Do NOT shrink the log file periodically. Shrinking the log should be done manually and only in rare cases, such as a large purge and you know you won't need that space for months to come. How often is log shipping backing up the transaction log and are those jobs successful? How big are the data files and how big are the ldf files?The log growth is likely due to index rebuilds or large transactions from the application. You just need to backup the tlog often enough to account for it. How often is dependent upon your system. We backup our tlogs every 15 minutes. We increase that to every 5 minutes if we have an upgrade happening where we'll be doing a lot of changes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
melaniemayfield
Starting Member
2 Posts |
Posted - 2013-09-03 : 18:21:23
|
| Thanks Tara, the logshipping is configured to backup every 15 minutes , our largest DB file is 52105 MB (PRIMARY Filegroup) and the log lie is 20126 MB, should we always see an increase in the ldf file?Kind RegardsMelanie |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Is shrink logged required?