InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 20:52:56 GMT20http://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspx[quote][b]jitendra.te (1/2/2013)[/b][hr]I have a Query Please help me out about this:Scenerio is, I have a database server which have a harddisk size is 70 GB c drives is occupied by OS. on which I have 2 databases DBA1 and DBA2 both database are live databases and configured in production environment.DBA1 and DBA2 are also configred with database mirroring without Automatic failover.Now on my Primary server in C drive[Size=30GB] datafiles are configured which is .mdf format and in D drive[Size=30GB] have Logfiles are storing DBA1 logfile size is 12 Gb and DBA2 logfile size is 13GB and these logfiles are growing everyday 500MB.[/quote] i found this configuration a bit confusing , you are saying that you have single harddisk with size 70gb plus you are using the same in production ? additionally you have mirrong setup too , what i am thinking here is apart from youre space issue you might be getting IO isssues too sooner or later. Wed, 02 Jan 2013 22:28:09 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspxTo simplify the fix for youWhat is the backup strategy you have implemented for these databases?You need to have log backups at regular intervals inorder to manage your transaction log growth.Please read the article referred above that makes you understand how transaction log files are managedWed, 02 Jan 2013 22:13:55 GMTRama Chandra Gowtham. Peddadahttp://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspxRead the article again.If your log is continually growing it's because you're mis-managing it. Most likely full recovery model with no log backups. Read the article, make sure you have appropriate log management going on. A properly managed transaction log does not continually grow.And no, you can't move it, you can't delete it. Not without potentially destroying your database.Wed, 02 Jan 2013 11:29:04 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspxHi,Thanks for quick response I have read the document.But as I mentioned this is a production database and my log is growing every day 500mb and It will be full in next 8 days.And it will create aproblem after 8 days I want something like automate that after 15 days automatic my log will move to some other NAS drive location is that possible to live databases?ThanksWed, 02 Jan 2013 09:12:05 GMTjitendra.tehttp://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspxPlease read through this - [url=http://www.sqlservercentral.com/articles/64582/]Managing Transaction Logs[/url]Wed, 02 Jan 2013 08:16:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspxThis would be a good start.http://www.sqlservercentral.com/articles/Administration/64582/Wed, 02 Jan 2013 08:12:07 GMTChrissy321http://www.sqlservercentral.com/Forums/Topic1401827-1292-1.aspxHello All,I have a Query Please help me out about this:Scenerio is, I have a database server which have a harddisk size is 70 GB c drives is occupied by OS. on which I have 2 databases DBA1 and DBA2 both database are live databases and configured in production environment.DBA1 and DBA2 are also configred with database mirroring without Automatic failover.Now on my Primary server in C drive[Size=30GB] datafiles are configured which is .mdf format and in D drive[Size=30GB] have Logfiles are storing DBA1 logfile size is 12 Gb and DBA2 logfile size is 13GB and these logfiles are growing everyday 500MB.Now how to manage these logfile?ThanksWed, 02 Jan 2013 07:20:07 GMTjitendra.te