I have a Highly pressured Production Environment with Database name
DB1. And I want to run a weekly
DBCC CHECKDB process on one of the databases there.
(You can understand,I can't do it on my production environment,Performance IMPACT).
So, I thought to use one of my Log-Shipping process.
I am have a Log-Shipping process, from
DB1_LS Database(Secondary) which locate in a distant server (DWH server).
Is there a way that I can take a full backup of the Secondary database
I want to be able, to restore it and run the
DBCC CHECKDB on it (
COPY-ONLY BACKUP ?)