I have the next scenario in SQL Server 2008: one big database (production DB). I want to backup this db then restore it on another server.
Then I do some delete operation from some big tables. After delete I want to shrink the database.
Then detach shrinked db, copy it on first (production) server, detach the big database and then attach the small one.
Now comes my problem: on the big (production database) the activity continued, and new records was inserted, updates done, deletes etc.
Will I be able to restore those operations from the transaction log on the new created small database? Is there a checkpoint before the first backup action? Will there be conflicts between the small DB transaction log and the big one's?
Any help (ideas, articles) would be greatly appreciated.