I have a client with 2 SQLServer boxes: CL01 and CL02. Each has its own set of databases, but there are 3 databases on CL01 that are mirrored over to CL02. The TDP backup on CL02 fails on those 3 databases because they are used in a mirror. The owner doesn't want to exclude those databases on CL02 in case of a failover. Then the databases will get backed up without having to change the exclude list.
Is there a way to have the TDP agent skip those files if they are actively in a mirror? The backup schedule event fails-402 every night and we need to look at the log to verify that it's just those 3 mirrors. Maybe there's a script or something we could run before the backup? Any ideas are appreciated. Bill Boyer "Hang in there, retirement is only thirty years away!" - ??
