May 28, 2013 at 11:30 pm
One of our production database is configured mirror , the log file growth around 150 GB, we need to shrink the log file
Anyone Help this one. How to shrink log file in mirrored database?
Any steps ?
Thanks
Jerry
May 29, 2013 at 12:06 am
May 29, 2013 at 12:12 am
solomon.jernas (5/28/2013)
One of our production database is configured mirror , the log file growth around 150 GB, we need to shrink the log file
I suspect you need to backup the log file, not shrink it. Without regular log backups, a database in full recovery model will have its log grow and grow and grow and the log will have no free space.
Please read through this - Managing Transaction Logs[/url] and http://www.sqlservercentral.com/articles/Transaction+Log/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
May 29, 2013 at 12:18 am
Any option shrink in mirrored db or only log backup will shrink the log size.
150 GB is occupied disk and it is going to full disk.
What to do for this situation ?
May 29, 2013 at 12:21 am
solomon.jernas (5/29/2013)
Any option shrink in mirrored db or only log backup will shrink the log size.
Log backups don't shrink the log, however if the log is full and growing, shrink won't do anything because there's no free space in the file.
What to do for this situation ?
You've been given references to articles, maybe read them?
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply