I have a situation where we have installed a new server with MS SQL 2005 and we need to migrate the database to the new server. The problem is that the Database is very large and highly fragmented. De-fragmenting it will take hours. So we have decided we would like to restore the full backup before the day of migrating so that we can defragment it on the new server and then restore the differential backup on the day of migrating.
Now we have two issues;
1. Will this work properly to restore the DB, defragment and then later restore the differential DB
2. Can we use logshipping, stop it on the way and defragment it, then continue with logshipping
3. Is there a better way of achieving this task.
Thanks in advance