SQL Server Performance

log shipping and veritas backup

Discussion in 'SQL Server Log Shipping' started by sunnylicious, Jun 24, 2005.

  1. sunnylicious New Member

    Hello, does anyone know if it is possible to back up a secondary sql server using veritas backup exec?
    Ive got a sql server on win 2k configured to recieve log shipping. It is a standby server, and I wanted to back it up with Veritas Backup exec. I get the following error message in Veritas

    Backup - machinename
    An error occurred on a query to database my_db.
    Database 'my_db' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.

    Does anyone have any experience in this configuration? I have also checked the Veritas boards in search of an answer. Any help would be appreciated. Thanks
  2. simondm New Member

    Unfortunatly you cannot backup a warm standby database - I have no idea why, it is very annoying. You can however stop the sql server service and then perform a NTFS backup of the database files. This is not the Microsoft recommended way of backups but it does work.

    Be warned some quirky things can happen though if you use things like replication as when you reattach the restored files the replication still exists unlike a sql recovery which will drop all of the replication. It can be tricky to remove, but if you are looking to do a bog standard backup and recovery then it should work fine.

  3. satya Moderator

    Rather you can use another backup solution like to copy the backup directories from the secondary server.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page