SQL Server Performance

Full Backups and Shipping compatibility

Discussion in 'SQL Server Log Shipping' started by asotalora, Jul 1, 2005.

  1. asotalora New Member

    Hi!
    Can I do full backups of a database that has the primary role in a logshipping? or maybe it is incompatible...
    I want to have backups of this database apart of having a copy in standby database.

    Greetings.
  2. surendrakalekar New Member

    Take full database backup


    Surendra Kalekar

  3. satya Moderator

    Yes you can continue full backup for the databases that are involved in log shipping, but ensure both the operations doesn't overlap.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. asotalora New Member

    Thanks for the response.<br /><img src='/community/emoticons/emotion-5.gif' alt=';)' />
  5. Why do you have to ensure that the two operations don't overlap? What would be the result if they did? I'm pretty sure I've had that situation and not had a report from the monitor that anything was out of sync.
  6. satya Moderator

    If backup database is performing and when you execute backup log then there will be a locking situation where it will fail backup log statement.

    In general it is suggested to continue full backup and pause the log shipping for a while until it finishes the full backup.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page