You are the administrator of a SQL Server 2008 instance with a database named AdventureWorks. The AdventureWorks database contains two tables as shown in the following table: 1. The Orders table…

You are the administrator of a SQL Server 2008 instance with a database named AdventureWorks. The AdventureWorks database contains two tables as shown in the following table: 1. The Orders table contains a table partition for each month. 2. The OrderHistory table contains two table partitions; one partition contains all data and the other partition is empty. 3. You plan to develop a process to move data from the partition that contains data for the oldest month of the Orders table to the appropriate partition of the OrderHistory table. 4. You need to ensure that the process can be repeated at the end of every month. What should you do?