Home Forums SQL Server 2008 SQL Server 2008 High Availability Log Shipping Scenario- DB at Secondary Server in Restoring Mode- DB's Log file containing drive got full-What to do? RE: Log Shipping Scenario- DB at Secondary Server in Restoring Mode- DB's Log file containing drive got full-What to do?

  • October 10, 2012 at 1:16 am

    #1547490

    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" 😉