SQL Server Performance Forum – Threads Archive

log shipping and veritas backup

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

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. Simon

Rather you can use another backup solution like to copy the backup directories from the secondary server. 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.

]]>