You need to ensure that when you restore a database on either server, the two databases are restored to a state that reflects the last time the job successfully executed
You need to design a solution that performs the following tasks: ·Removes full-table scans ·Allows the query optimizer to select the appropriate index