DPM 2007 clashing with existing SQL backup job
- by Paul D'Ambra
I've recently installed a DPM2007 server on Server 2003 and have set up a protection group against a server 2003 server running SQL 2005 SP3.
The SQL server in question has a full backup (as a sql agent job) once a day and transaction log backups hourly. These are zipped up and FTP'd to a server offsite by a scheduled task.
Since adding the DPM job I'm receiving many error messages:
DPM tried to do a SQL log backup,
either as part of a backup job or a
recovery to latest point in time job.
The SQL log backup job has detected a
discontinuity in the SQL log chain for
database SERVER_NAME\DB_Name since the
last backup. All incremental backup
jobs will fail until an express full
backup runs.
My google-fu suggests that I need to change the full backup my sqlagent job is running to a copy_only job. But I think this means that I can't use that backup with the transaction_logs to restore the database if the building (including the DPM server) burns down.
I'm sure I'm missing something obvious and thought I'd see what the hivemind suggests.
It is an option to set-up a co-located DPM server elsewhere and have DPM stream the backup but that's obviously more expensive than the current set up.
Many thanks in advance