You will use C# to communicate with SQL Server 2008 to create two Maintenance Plans. You can use other languages to obtain the desired results; however, the call will be originating from C#.
1. Create a simple GUI with at least a text box and a label and two buttons. The text box will be the input of the Server Name. The label will display which version of SQL Server you are running. Windows Authentication will be used to log into SQL Server, so login info is not necessary.
2. Write a method that retrieves the version of SQL Server. If you are unable to login to SQL Server, the label should display that it was unable to login, otherwise, it should display the version of SQL and if it is 2008 or not. (example: "You have SQL Server 2008" or "You are not using SQL Server 2008, you have SQL Server 2005")
3. Create 2 Maintenance plans. Button 1 will create the first maintenance plan and be disabled if it exists. Button 2 will create the second maintenance plan and be disabled if it exists. These should both be their own methods for me to call. First one should be called CreateMaintenancePlan(), second one should be called CreateOptiimizationPlan(). Add which ever parameters you need. Throw exceptions in methods if they fail, I'll catch them from my call.
4. Change the SQL Server Agent Jobs of these two plans to have Owner of "sa".
You final result should be 2 maintenance plans with "sa" owner as if you had gone through the maintenance plan wizard twice in SQL Server 2008. I'll supply images of each page of the wizard so you can see the relevant changes.
Please only bid if you know how to create Maintenance plans with code.
People with no feedback will NOT be considered as they have failed me on multiple occasions.
To make things a little easier, I just need a way to restore a maintenance plan, using C#, that I exported from Integration Services and have it set to SA. The only thing I'll need changed in here is the drive letters for the location of the bak files.