Database mirroring and log growth

Hi all:
I have implemented database mirroring and it is working great. However, the
database log files are growing and growing and growing... is there a way to
manage the size of the log files?
ThanksHi Jim
Have you seen http://msdn2.microsoft.com/en-us/library/ms345414.aspx. If the
mirror is significantly behind the log file will grow.
John
"Jim Norton" wrote:

> Hi all:
> I have implemented database mirroring and it is working great. However, t
he
> database log files are growing and growing and growing... is there a way t
o
> manage the size of the log files?
> Thanks
>
>sql

Database mirroring and log growth

Hi all:
I have implemented database mirroring and it is working great. However, the
database log files are growing and growing and growing... is there a way to
manage the size of the log files?
Thanks
Hi Jim
Have you seen http://msdn2.microsoft.com/en-us/library/ms345414.aspx. If the
mirror is significantly behind the log file will grow.
John
"Jim Norton" wrote:

> Hi all:
> I have implemented database mirroring and it is working great. However, the
> database log files are growing and growing and growing... is there a way to
> manage the size of the log files?
> Thanks
>
>

Database mirroring and log file growth

Is there a way to shrink the log file while using database mirroring?
We have a 20 GB database with a log file about 80 GB.
Transaction log backup is done every 30 minutes, full backup each night, but the log file is not truncated.

Since it seems that the log file grows about 1 GB each day (we have migrated from sql2000 about 50 days ago) we are going to run out of disk space in a few weeks!

Ivan

refer this link,

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=377087

they have suggested to ,issue checkpoint and then truncate log......

USE XXX
GO
CHECKPOINT
GO
BACKUP LOG [XXX] TO [XXX_TLOG] WITH NOFORMAT, INIT, NAME = N'XXX-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
DBCC SHRINKFILE(XXX_Log, 1)
GO

|||

Is the Database also part of replication ?

Is the Database Mirroring Active , STATE = SYNCRONIZED ?

|||just try the above method and get back if its not possible you need to remove mirroring

refer, http://technet.microsoft.com/en-us/library/ms189112.aspx then try to truncate the tran log and try to shrink using dbcc shrinkfile........i am not sure which of the above 2 will work out.........|||

Removing and Reestablishing mirroring for a large database might be some work , again it depends how quickly you want to fix it , however what i will suggest ; check if the scheduled TLOG backups are successfull ? if the database is acting as a publisher in replication topology ; also if you could post the mode of mirroring Sync or Async ?

database log growth too fast

Dear all

My database log growth is too fast. I want to stop this situation. I am a rookie in database administration. Please give me some suggestions. Thanks a lot.

Alex

Perhaps you are able to shrink this from time to time within a maintaince plan, or a manually setup jon in SQL Server ?

http://www.aspfaq.com/show.asp?id=2471

HTH, jens Suessmeyer.|||thx