December 3, 2013 at 11:31 pm
HI All,
In Production server, Principal database having 120GB log file(mirroring configured)
Why ldf file is taking that much space, How I can truncate log file.?
What is best way to shrink log file?
December 3, 2013 at 11:49 pm
Do you have regular log backups running? If not, that's why the log is so large.
Please read through these:
http://www.sqlservercentral.com/articles/Administration/64582/
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 3, 2013 at 11:55 pm
GilaMonster (12/3/2013)
Do you have regular log backups running? If not, that's why the log is so large.
Thanks for u r quick reply , We are not taking log backups but we are taking week full backup.
If i take log backup from principal server, is there any impact on mirroring ?
December 3, 2013 at 11:58 pm
PRR.DB (12/3/2013)
We are not taking log backups but we are taking week full backup.
There's your problem. If a database is in full recovery, and for mirroring it has to be in full recovery, you MUST take regular log backups or the log will grow until it fills the disk. Please read the two articles I referenced.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply