November 27, 2007 at 12:33 am
As we using SQL 2005 Server, Our DB Size is 7.5 GB
Recovery Option is SET to Full Recovery model.
and Mirroring also configured for High Availablity.
and at the same time Replication also used for
Table based data replicatin from branch Office Servers.
My problem is due to above the LOG File is growing continuously
Auto Shrink is enabled but its no working
By the time I am manually trancate the log file by Attach and detach
Database.
I need suggestion to control this Log file growth controlled automatically
If anybody have solution please help
November 27, 2007 at 1:41 am
Change the Log File auto grow property thro' SQL Server Management Studio.
(Select Database -> Properties -> Files...)
November 27, 2007 at 1:42 am
Hi,
You need to create a job to check if the log growth reach a certain threshold, then make the truncate of log.
Managing SQL Server 2000 Transaction Log Growth
http://www.mssqltips.com/tip.asp?tip=950
Check the following post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56434
regards,
Ahmed
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply