Skip to Content
Former Member
Oct 19, 2006 at 02:42 AM

How to best backup a 4.6c system / msSQL 2000


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!


Adam Oakeley