Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Shipping Scenario- DB at Secondary Server in Restoring Mode- DB's Log file containing drive got full-What to do? Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 1:27 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, August 18, 2014 1:47 PM
Points: 665, Visits: 1,105
Log Shipping is set from Server A to Server B for database X
SQL Server 2008 Std Edn 64 bit on both servers
Database X State at Secondary Server (B): Restoring

Problem: 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
Post #1370555
Posted Tuesday, October 9, 2012 9:46 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 5:02 PM
Points: 81, Visits: 914
What is ur drive size in which your log files are and what is the size of the Database that is being logshipped.
Post #1370660
Posted Wednesday, October 10, 2012 1:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 6,291, Visits: 13,552
ankur_libra (10/9/2012)
Log Shipping is set from Server A to Server B for database X
SQL Server 2008 Std Edn 64 bit on both servers
Database X State at Secondary Server (B): Restoring

Problem: 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

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?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1370726
Posted Wednesday, October 10, 2012 6:14 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, August 18, 2014 1:47 PM
Points: 665, Visits: 1,105
Hi,

Mahesh:
Drive size in which DB log file is placed at secondary server: 25 GB
Size 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 days

Thanks,

Regards,

Ankur


Post #1370877
Posted Wednesday, October 10, 2012 7:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 6,291, Visits: 13,552
OK, 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.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1370905
Posted Wednesday, October 10, 2012 2:08 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, August 18, 2014 1:47 PM
Points: 665, Visits: 1,105

Hi 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


Post #1371111
Posted Wednesday, October 10, 2012 3:04 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 6,291, Visits: 13,552
ankur_libra (10/10/2012)
Restore job runs after every 15 minutes.

OK, so you probably don't need a 3 day retention period



ankur_libra (10/10/2012)
Can you please suggest as per current scenario, where Log file containing disk at secondary server got full?

Check the server and see what's filling up the drive!!



ankur_libra (10/10/2012)
Do we have any other optioin to resolve this issue apart from reconfiguring log shipping?

Why do you want to reconfigure Log Shipping?
You can change the retention without reconfiguring LS.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1371132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse