July 9, 2009 at 9:29 am
I have a replicated database I built back in May. The database is now 13Gb, but the log file is at 31Gb. I have 14Gb left on the drive. I've tried shrinking the file and backing up with truncate only, but it doesn't seem to help. This is a replicated database if that makes any difference. How can I get that log file back down to a reasonable size?
July 9, 2009 at 9:32 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750357-146-1.aspx
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
July 9, 2009 at 9:33 am
Did you check whether or not your replication works? Replication can hold the logs so that you cannot truncate them.
July 9, 2009 at 9:33 am
Did you check whether or not your replication works? Replication can hold the logs so that you cannot truncate them.
July 9, 2009 at 9:34 am
No more replies to this thread please.
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