quackhandle1975 (2/25/2014)
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.
CheckDB/reindex/stats/compat level/etc require that the full backup was restored WITH RECOVERY. Once the database has been recovered, no further backups can be applied. To restore that differential that you're planning to take, you'd have to restore the full backup again, from scratch, then restore the diff, then run all your checkDB, reindex, update stats, set compat level, etc.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability