Hi, I have a client with msSQL 2000. Currently trying to use log shipping for a "hot spare" and also backup the database to tape. As expected, using backup outside of the log shipping database plan results in 2 sets of un-usable backups. Is the best plan to use log shipping and backup using the log shipping plan and then backup the resulting backup chunk files to tape? What other pit-falls will we encounter if relying on msSQL backup API and resulting TLOG checkpoint issues?
Any insight is welcome!