InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:40:16 GMT20http://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspx[quote][b]ankur_libra (10/10/2012)[/b][hr]Restore job runs after every 15 minutes. [/quote]OK, so you probably don't need a 3 day retention period[quote][b]ankur_libra (10/10/2012)[/b][hr]Can you please suggest as per current scenario, where Log file containing disk at secondary server got full? [/quote]Check the server and see what's filling up the drive!![quote][b]ankur_libra (10/10/2012)[/b][hr]Do we have any other optioin to resolve this issue apart from reconfiguring log shipping?[/quote]Why do you want to reconfigure Log Shipping?You can change the retention without reconfiguring LS.Wed, 10 Oct 2012 15:04:30 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspxHi Perry:Restore job runs after every 15 minutes. Suggested points are Ok for future perspective.Can you please suggest as per current scenario, where Log file containing disk at secondary server got full? Do we have any other optioin to resolve this issue apart from reconfiguring log shipping?Thanks,Regards,Ankur Wed, 10 Oct 2012 14:08:48 GMTankur_librahttp://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspxOK, so how often are the restores being applied by the restore job?If they're restored hourly you could probably reduce the retention on the secondary, either that or get more disk space to support the retention period.Wed, 10 Oct 2012 07:06:25 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspxHi,Mahesh: Drive size in which DB log file is placed at secondary server: 25 GBSize of the Database that is being logshipped: 23 GBs Perry:Databse log file containing drive at secondary server is full. All other locations like the backup location on the primary, the copy location on the secondary has enough disk space.What retention values did you set for your LS plan? Delete Copied files after 3 daysThanks,Regards,AnkurWed, 10 Oct 2012 06:14:18 GMTankur_librahttp://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspx[quote][b]ankur_libra (10/9/2012)[/b][hr]Log Shipping is set from Server A to Server B for database XSQL Server 2008 Std Edn 64 bit on both serversDatabase X State at Secondary Server (B): RestoringProblem: DB's Log file containing drive got full-What to do?Please suggest any plans to overcome this situation other than to reconfigure it.Thanks in advance,Regards,Ankur[/quote]Which location is full, the backup location on the primary or the copy location on the secondary?What retention values did you set for your LS plan?Wed, 10 Oct 2012 01:16:00 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspxWhat is ur drive size in which your log files are and what is the size of the Database that is being logshipped.Tue, 09 Oct 2012 21:46:00 GMTmahesh.dasonihttp://www.sqlservercentral.com/Forums/Topic1370555-1549-1.aspxLog Shipping is set from Server A to Server B for database XSQL Server 2008 Std Edn 64 bit on both serversDatabase X State at Secondary Server (B): RestoringProblem: DB's Log file containing drive got full-What to do?Please suggest any plans to overcome this situation other than to reconfigure it.Thanks in advance,Regards,AnkurTue, 09 Oct 2012 13:27:24 GMTankur_libra