quackhandle1975 (2/25/2014)
Hi,quick sanity check here: migrating from SQL 2005 to 2008 R2. I'm looking to take a full bk up on Source 2005 instance and copy/ restore to 2008. I am then propsing to apply the checkdb/reindex/update stats/compatibility/etc scripts on the migrated databases.
During the migration I will set read-only on source, take a differential and apply this to target instance to get latest data. My question (sorry bit longwinded) is can I take a COPY_ONLY backup (on the target instance) after the checkdb/reindex/update stats/compatibility/etc scripts but before I apply the differential but it won't impact the differential?
qh
If I got your question.
You are planning to take a full backup and restore it to target with norecovery and then apply differential with recovery.
If this is the case, you cannot take any backup in leaving in restoring mode.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/